{
 "cells": [
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# amap.com 搜索 api/search：步步学\n",
    "- B. 集成一步到位的代码见\n",
    " [research_amap_search_NewMedia_cities_onestop.ipynb](research_amap_search_NewMedia_cities_onestop.ipynb) \n",
    "- C. 包成函数的代码见\n",
    " [research_amap_search_NewMedia_cities_function.ipynb](research_amap_search_NewMedia_cities_function.ipynb)\n",
    "- API文件：[搜索api/search](http://lbs.amap.com/api/webservice/guide/api/search)\n",
    " - 必读：原文件内容：「parameters代表的参数包括必填参数和可选参数。所有参数均使用和号字符(&)进行分隔。下面的列表枚举了这些参数及其使用规则。」\n",
    " - 必查：请求参数"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 1. 使用Python requests 模块及amap API 取得一次返回数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 1,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests #用於API HTTP requests\n",
    "# 使用python字典构造 parameters 请求参数\n",
    "# API使用请求参数：必填之 请求服务权限标识  见  必查：请求参数\n",
    "parameters = {'key': '你自己申請到的key'}  # 高德地图API 获取Key\n",
    "\n",
    "# 使用python字典方法update()更新参数字典\n",
    "# API使用请求参数：必填之 请求服务权限标识  见  必查：请求参数\n",
    "# 查询关键字(必填)   查询城市(可选)   仅返回指定城市数据(可选)\n",
    "parameters.update( {'keywords': '植物园',\n",
    "                    'city':     '440000',\n",
    "                    'citylimit': True\n",
    "                   } )\n",
    "r = requests.get (\"http://restapi.amap.com/v3/place/text\", params=parameters)\n",
    "\n",
    "# requests 模塊\n",
    "data = r.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 补充内容：若对reguests.get及r.json() 不懂\n",
    "- requests 模块 [快速上手](http://docs.python-requests.org/zh_CN/latest/user/quickstart.html)\n",
    " - 发送请求\n",
    " - 传递 URL 参数\n",
    " - JSON 响应内容"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 检视结果"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "{'count': '193',\n",
       " 'info': 'OK',\n",
       " 'infocode': '10000',\n",
       " 'pois': [{'address': '天源路1190号',\n",
       "   'adname': '天河区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '广州市',\n",
       "   'distance': [],\n",
       "   'id': 'B00140UEO5',\n",
       "   'importance': [],\n",
       "   'location': '113.367196,23.181797',\n",
       "   'name': '华南植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '020-85231993;020-85232037',\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '仙湖路160号',\n",
       "   'adname': '罗湖区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '深圳市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F37T4NJ',\n",
       "   'importance': [],\n",
       "   'location': '114.174956,22.578596',\n",
       "   'name': '深圳仙湖植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0755-25738430;0755-25722184',\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '健民路328号',\n",
       "   'adname': '香洲区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '珠海市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F4000E1',\n",
       "   'importance': [],\n",
       "   'location': '113.52128,22.29402',\n",
       "   'name': '农科奇观',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0756-8535999;0756-8535888',\n",
       "   'type': '风景名胜;风景名胜;国家级景点',\n",
       "   'typecode': '110202'},\n",
       "  {'address': '湖秀新村1号(近湖光岩)',\n",
       "   'adname': '麻章区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '湛江市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F701056',\n",
       "   'importance': [],\n",
       "   'location': '110.275886,21.168908',\n",
       "   'name': '南亚热带植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0759-2859145;12301',\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '新港大道',\n",
       "   'adname': '南沙区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '广州市',\n",
       "   'distance': [],\n",
       "   'id': 'B00140UFWZ',\n",
       "   'importance': [],\n",
       "   'location': '113.620092,22.628194',\n",
       "   'name': '百万葵园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '020-84956360;020-83309917;020-84956863',\n",
       "   'type': '风景名胜;公园广场;公园',\n",
       "   'typecode': '110101'},\n",
       "  {'address': '月亮湾青青路1号',\n",
       "   'adname': '南山区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '深圳市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F30242B',\n",
       "   'importance': [],\n",
       "   'location': '113.900516,22.500264',\n",
       "   'name': '月亮湾公园-青青世界',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0755-26403988;0755-26646988;0755-26737330',\n",
       "   'type': '风景名胜;风景名胜;风景名胜',\n",
       "   'typecode': '110200'},\n",
       "  {'address': '和二一路32号',\n",
       "   'adname': '宝安区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '深圳市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F37VJA4',\n",
       "   'importance': [],\n",
       "   'location': '113.770048,22.726385',\n",
       "   'name': '海上田园-趣味植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;风景名胜;风景名胜',\n",
       "   'typecode': '110200'},\n",
       "  {'address': '广益街道官湖开发区',\n",
       "   'adname': '澄海区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '汕头市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F2008RH',\n",
       "   'importance': [],\n",
       "   'location': '116.756359,23.502012',\n",
       "   'name': '科隆千树园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0754-85858327;0754-86985976',\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '体育南路近体育馆',\n",
       "   'adname': '赤坎区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '湛江市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F70NY85',\n",
       "   'importance': [],\n",
       "   'location': '110.389479,21.251218',\n",
       "   'name': '南国热带花园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0759-3480019',\n",
       "   'type': '风景名胜;公园广场;公园',\n",
       "   'typecode': '110101'},\n",
       "  {'address': '海湾大桥旁',\n",
       "   'adname': '赤坎区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '湛江市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F701S9V',\n",
       "   'importance': [],\n",
       "   'location': '110.409452,21.243933',\n",
       "   'name': '中澳友谊花园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;公园广场;公园',\n",
       "   'typecode': '110101'},\n",
       "  {'address': '城郊街西和村',\n",
       "   'adname': '从化区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '广州市',\n",
       "   'distance': [],\n",
       "   'id': 'B00141ICC6',\n",
       "   'importance': [],\n",
       "   'location': '113.583777,23.623854',\n",
       "   'name': '宝趣玫瑰世界',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '020-87907777',\n",
       "   'type': '风景名胜;风景名胜;省级景点',\n",
       "   'typecode': '110203'},\n",
       "  {'address': '古镇海洲东岸北路396号',\n",
       "   'adname': '中山市',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '中山市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F80OWVE',\n",
       "   'importance': [],\n",
       "   'location': '113.199458,22.654432',\n",
       "   'name': '南方绿博园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;风景名胜;风景名胜',\n",
       "   'typecode': '110200'},\n",
       "  {'address': '325国道旁',\n",
       "   'adname': '电白区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '茂名市',\n",
       "   'distance': [],\n",
       "   'id': 'B029C026TX',\n",
       "   'importance': [],\n",
       "   'location': '110.906533,21.455614',\n",
       "   'name': '茂名市珍稀植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0668-2699020',\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '东湖公园',\n",
       "   'adname': '罗湖区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '深圳市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F38I7NS',\n",
       "   'importance': [],\n",
       "   'location': '114.147043,22.563770',\n",
       "   'name': '东湖公园-杜鹃园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;公园广场;公园',\n",
       "   'typecode': '110101'},\n",
       "  {'address': '逸仙路君华新城附近',\n",
       "   'adname': '中山市',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '中山市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F80OXEE',\n",
       "   'importance': [],\n",
       "   'location': '113.480887,22.539581',\n",
       "   'name': '华佗山公园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;公园广场;公园',\n",
       "   'typecode': '110101'},\n",
       "  {'address': 'G15沈海高速出口',\n",
       "   'adname': '徐闻县',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '湛江市',\n",
       "   'distance': [],\n",
       "   'id': 'B02F701R7Y',\n",
       "   'importance': [],\n",
       "   'location': '110.140605,20.382517',\n",
       "   'name': '中国科学院华南植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '323国道附近',\n",
       "   'adname': '仁化县',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '韶关市',\n",
       "   'distance': [],\n",
       "   'id': 'B02EF0IAI5',\n",
       "   'importance': [],\n",
       "   'location': '113.819593,24.960177',\n",
       "   'name': '丹霞山灵溪河森林公园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '0751-6977261;0751-6291683',\n",
       "   'type': '风景名胜;风景名胜;风景名胜',\n",
       "   'typecode': '110200'},\n",
       "  {'address': '花山镇铁山村',\n",
       "   'adname': '花都区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '广州市',\n",
       "   'distance': [],\n",
       "   'id': 'B00141K7U7',\n",
       "   'importance': [],\n",
       "   'location': '113.26085,23.464305',\n",
       "   'name': '香草世界',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': '020-66609112;020-66609118',\n",
       "   'type': '风景名胜;风景名胜相关;旅游景点',\n",
       "   'typecode': '110000'},\n",
       "  {'address': '新会劳动大学附近',\n",
       "   'adname': '新会区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '江门市',\n",
       "   'distance': [],\n",
       "   'id': 'B02EE01Q23',\n",
       "   'importance': [],\n",
       "   'location': '113.036400,22.549087',\n",
       "   'name': '圭峰山风景名胜区-圭峰植物园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'},\n",
       "  {'address': '马岗岭街67号',\n",
       "   'adname': '白云区',\n",
       "   'biz_ext': [],\n",
       "   'biz_type': 'tour',\n",
       "   'cityname': '广州市',\n",
       "   'distance': [],\n",
       "   'id': 'B00141JAZ8',\n",
       "   'importance': [],\n",
       "   'location': '113.256478,23.267326',\n",
       "   'name': '石马桃花公园',\n",
       "   'pname': '广东省',\n",
       "   'poiweight': [],\n",
       "   'shopid': [],\n",
       "   'shopinfo': '2',\n",
       "   'tel': [],\n",
       "   'type': '风景名胜;公园广场;植物园',\n",
       "   'typecode': '110103'}],\n",
       " 'status': '1',\n",
       " 'suggestion': {'cities': [], 'keywords': []}}"
      ]
     },
     "execution_count": 2,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 检视结果 方式A\n",
    "data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 3,
   "metadata": {
    "scrolled": true
   },
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'status': '1', 'count': '193', 'info': 'OK', 'infocode': '10000', 'suggestion': {'keywords': [], 'cities': []}, 'pois': [{'id': 'B00140UEO5', 'name': '华南植物园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '天源路1190号', 'location': '113.367196,23.181797', 'tel': '020-85231993;020-85232037', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '广州市', 'adname': '天河区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F37T4NJ', 'name': '深圳仙湖植物园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '仙湖路160号', 'location': '114.174956,22.578596', 'tel': '0755-25738430;0755-25722184', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '深圳市', 'adname': '罗湖区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F4000E1', 'name': '农科奇观', 'type': '风景名胜;风景名胜;国家级景点', 'typecode': '110202', 'biz_type': 'tour', 'address': '健民路328号', 'location': '113.52128,22.29402', 'tel': '0756-8535999;0756-8535888', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '珠海市', 'adname': '香洲区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F701056', 'name': '南亚热带植物园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '湖秀新村1号(近湖光岩)', 'location': '110.275886,21.168908', 'tel': '0759-2859145;12301', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '湛江市', 'adname': '麻章区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B00140UFWZ', 'name': '百万葵园', 'type': '风景名胜;公园广场;公园', 'typecode': '110101', 'biz_type': 'tour', 'address': '新港大道', 'location': '113.620092,22.628194', 'tel': '020-84956360;020-83309917;020-84956863', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '广州市', 'adname': '南沙区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F30242B', 'name': '月亮湾公园-青青世界', 'type': '风景名胜;风景名胜;风景名胜', 'typecode': '110200', 'biz_type': 'tour', 'address': '月亮湾青青路1号', 'location': '113.900516,22.500264', 'tel': '0755-26403988;0755-26646988;0755-26737330', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '深圳市', 'adname': '南山区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F37VJA4', 'name': '海上田园-趣味植物园', 'type': '风景名胜;风景名胜;风景名胜', 'typecode': '110200', 'biz_type': 'tour', 'address': '和二一路32号', 'location': '113.770048,22.726385', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '深圳市', 'adname': '宝安区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F2008RH', 'name': '科隆千树园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '广益街道官湖开发区', 'location': '116.756359,23.502012', 'tel': '0754-85858327;0754-86985976', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '汕头市', 'adname': '澄海区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F70NY85', 'name': '南国热带花园', 'type': '风景名胜;公园广场;公园', 'typecode': '110101', 'biz_type': 'tour', 'address': '体育南路近体育馆', 'location': '110.389479,21.251218', 'tel': '0759-3480019', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '湛江市', 'adname': '赤坎区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F701S9V', 'name': '中澳友谊花园', 'type': '风景名胜;公园广场;公园', 'typecode': '110101', 'biz_type': 'tour', 'address': '海湾大桥旁', 'location': '110.409452,21.243933', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '湛江市', 'adname': '赤坎区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B00141ICC6', 'name': '宝趣玫瑰世界', 'type': '风景名胜;风景名胜;省级景点', 'typecode': '110203', 'biz_type': 'tour', 'address': '城郊街西和村', 'location': '113.583777,23.623854', 'tel': '020-87907777', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '广州市', 'adname': '从化区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F80OWVE', 'name': '南方绿博园', 'type': '风景名胜;风景名胜;风景名胜', 'typecode': '110200', 'biz_type': 'tour', 'address': '古镇海洲东岸北路396号', 'location': '113.199458,22.654432', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '中山市', 'adname': '中山市', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B029C026TX', 'name': '茂名市珍稀植物园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '325国道旁', 'location': '110.906533,21.455614', 'tel': '0668-2699020', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '茂名市', 'adname': '电白区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F38I7NS', 'name': '东湖公园-杜鹃园', 'type': '风景名胜;公园广场;公园', 'typecode': '110101', 'biz_type': 'tour', 'address': '东湖公园', 'location': '114.147043,22.563770', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '深圳市', 'adname': '罗湖区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F80OXEE', 'name': '华佗山公园', 'type': '风景名胜;公园广场;公园', 'typecode': '110101', 'biz_type': 'tour', 'address': '逸仙路君华新城附近', 'location': '113.480887,22.539581', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '中山市', 'adname': '中山市', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02F701R7Y', 'name': '中国科学院华南植物园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': 'G15沈海高速出口', 'location': '110.140605,20.382517', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '湛江市', 'adname': '徐闻县', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02EF0IAI5', 'name': '丹霞山灵溪河森林公园', 'type': '风景名胜;风景名胜;风景名胜', 'typecode': '110200', 'biz_type': 'tour', 'address': '323国道附近', 'location': '113.819593,24.960177', 'tel': '0751-6977261;0751-6291683', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '韶关市', 'adname': '仁化县', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B00141K7U7', 'name': '香草世界', 'type': '风景名胜;风景名胜相关;旅游景点', 'typecode': '110000', 'biz_type': 'tour', 'address': '花山镇铁山村', 'location': '113.26085,23.464305', 'tel': '020-66609112;020-66609118', 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '广州市', 'adname': '花都区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B02EE01Q23', 'name': '圭峰山风景名胜区-圭峰植物园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '新会劳动大学附近', 'location': '113.036400,22.549087', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '江门市', 'adname': '新会区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}, {'id': 'B00141JAZ8', 'name': '石马桃花公园', 'type': '风景名胜;公园广场;植物园', 'typecode': '110103', 'biz_type': 'tour', 'address': '马岗岭街67号', 'location': '113.256478,23.267326', 'tel': [], 'distance': [], 'biz_ext': [], 'pname': '广东省', 'cityname': '广州市', 'adname': '白云区', 'importance': [], 'shopid': [], 'shopinfo': '2', 'poiweight': []}]}\n"
     ]
    }
   ],
   "source": [
    "# 检视结果 方式B\n",
    "print(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 4,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "{'count': '193',\n",
      " 'info': 'OK',\n",
      " 'infocode': '10000',\n",
      " 'pois': [{'address': '天源路1190号',\n",
      "           'adname': '天河区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '广州市',\n",
      "           'distance': [],\n",
      "           'id': 'B00140UEO5',\n",
      "           'importance': [],\n",
      "           'location': '113.367196,23.181797',\n",
      "           'name': '华南植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '020-85231993;020-85232037',\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '仙湖路160号',\n",
      "           'adname': '罗湖区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '深圳市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F37T4NJ',\n",
      "           'importance': [],\n",
      "           'location': '114.174956,22.578596',\n",
      "           'name': '深圳仙湖植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0755-25738430;0755-25722184',\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '健民路328号',\n",
      "           'adname': '香洲区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '珠海市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F4000E1',\n",
      "           'importance': [],\n",
      "           'location': '113.52128,22.29402',\n",
      "           'name': '农科奇观',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0756-8535999;0756-8535888',\n",
      "           'type': '风景名胜;风景名胜;国家级景点',\n",
      "           'typecode': '110202'},\n",
      "          {'address': '湖秀新村1号(近湖光岩)',\n",
      "           'adname': '麻章区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '湛江市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F701056',\n",
      "           'importance': [],\n",
      "           'location': '110.275886,21.168908',\n",
      "           'name': '南亚热带植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0759-2859145;12301',\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '新港大道',\n",
      "           'adname': '南沙区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '广州市',\n",
      "           'distance': [],\n",
      "           'id': 'B00140UFWZ',\n",
      "           'importance': [],\n",
      "           'location': '113.620092,22.628194',\n",
      "           'name': '百万葵园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '020-84956360;020-83309917;020-84956863',\n",
      "           'type': '风景名胜;公园广场;公园',\n",
      "           'typecode': '110101'},\n",
      "          {'address': '月亮湾青青路1号',\n",
      "           'adname': '南山区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '深圳市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F30242B',\n",
      "           'importance': [],\n",
      "           'location': '113.900516,22.500264',\n",
      "           'name': '月亮湾公园-青青世界',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0755-26403988;0755-26646988;0755-26737330',\n",
      "           'type': '风景名胜;风景名胜;风景名胜',\n",
      "           'typecode': '110200'},\n",
      "          {'address': '和二一路32号',\n",
      "           'adname': '宝安区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '深圳市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F37VJA4',\n",
      "           'importance': [],\n",
      "           'location': '113.770048,22.726385',\n",
      "           'name': '海上田园-趣味植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;风景名胜;风景名胜',\n",
      "           'typecode': '110200'},\n",
      "          {'address': '广益街道官湖开发区',\n",
      "           'adname': '澄海区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '汕头市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F2008RH',\n",
      "           'importance': [],\n",
      "           'location': '116.756359,23.502012',\n",
      "           'name': '科隆千树园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0754-85858327;0754-86985976',\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '体育南路近体育馆',\n",
      "           'adname': '赤坎区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '湛江市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F70NY85',\n",
      "           'importance': [],\n",
      "           'location': '110.389479,21.251218',\n",
      "           'name': '南国热带花园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0759-3480019',\n",
      "           'type': '风景名胜;公园广场;公园',\n",
      "           'typecode': '110101'},\n",
      "          {'address': '海湾大桥旁',\n",
      "           'adname': '赤坎区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '湛江市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F701S9V',\n",
      "           'importance': [],\n",
      "           'location': '110.409452,21.243933',\n",
      "           'name': '中澳友谊花园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;公园广场;公园',\n",
      "           'typecode': '110101'},\n",
      "          {'address': '城郊街西和村',\n",
      "           'adname': '从化区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '广州市',\n",
      "           'distance': [],\n",
      "           'id': 'B00141ICC6',\n",
      "           'importance': [],\n",
      "           'location': '113.583777,23.623854',\n",
      "           'name': '宝趣玫瑰世界',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '020-87907777',\n",
      "           'type': '风景名胜;风景名胜;省级景点',\n",
      "           'typecode': '110203'},\n",
      "          {'address': '古镇海洲东岸北路396号',\n",
      "           'adname': '中山市',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '中山市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F80OWVE',\n",
      "           'importance': [],\n",
      "           'location': '113.199458,22.654432',\n",
      "           'name': '南方绿博园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;风景名胜;风景名胜',\n",
      "           'typecode': '110200'},\n",
      "          {'address': '325国道旁',\n",
      "           'adname': '电白区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '茂名市',\n",
      "           'distance': [],\n",
      "           'id': 'B029C026TX',\n",
      "           'importance': [],\n",
      "           'location': '110.906533,21.455614',\n",
      "           'name': '茂名市珍稀植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0668-2699020',\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '东湖公园',\n",
      "           'adname': '罗湖区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '深圳市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F38I7NS',\n",
      "           'importance': [],\n",
      "           'location': '114.147043,22.563770',\n",
      "           'name': '东湖公园-杜鹃园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;公园广场;公园',\n",
      "           'typecode': '110101'},\n",
      "          {'address': '逸仙路君华新城附近',\n",
      "           'adname': '中山市',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '中山市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F80OXEE',\n",
      "           'importance': [],\n",
      "           'location': '113.480887,22.539581',\n",
      "           'name': '华佗山公园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;公园广场;公园',\n",
      "           'typecode': '110101'},\n",
      "          {'address': 'G15沈海高速出口',\n",
      "           'adname': '徐闻县',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '湛江市',\n",
      "           'distance': [],\n",
      "           'id': 'B02F701R7Y',\n",
      "           'importance': [],\n",
      "           'location': '110.140605,20.382517',\n",
      "           'name': '中国科学院华南植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '323国道附近',\n",
      "           'adname': '仁化县',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '韶关市',\n",
      "           'distance': [],\n",
      "           'id': 'B02EF0IAI5',\n",
      "           'importance': [],\n",
      "           'location': '113.819593,24.960177',\n",
      "           'name': '丹霞山灵溪河森林公园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '0751-6977261;0751-6291683',\n",
      "           'type': '风景名胜;风景名胜;风景名胜',\n",
      "           'typecode': '110200'},\n",
      "          {'address': '花山镇铁山村',\n",
      "           'adname': '花都区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '广州市',\n",
      "           'distance': [],\n",
      "           'id': 'B00141K7U7',\n",
      "           'importance': [],\n",
      "           'location': '113.26085,23.464305',\n",
      "           'name': '香草世界',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': '020-66609112;020-66609118',\n",
      "           'type': '风景名胜;风景名胜相关;旅游景点',\n",
      "           'typecode': '110000'},\n",
      "          {'address': '新会劳动大学附近',\n",
      "           'adname': '新会区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '江门市',\n",
      "           'distance': [],\n",
      "           'id': 'B02EE01Q23',\n",
      "           'importance': [],\n",
      "           'location': '113.036400,22.549087',\n",
      "           'name': '圭峰山风景名胜区-圭峰植物园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'},\n",
      "          {'address': '马岗岭街67号',\n",
      "           'adname': '白云区',\n",
      "           'biz_ext': [],\n",
      "           'biz_type': 'tour',\n",
      "           'cityname': '广州市',\n",
      "           'distance': [],\n",
      "           'id': 'B00141JAZ8',\n",
      "           'importance': [],\n",
      "           'location': '113.256478,23.267326',\n",
      "           'name': '石马桃花公园',\n",
      "           'pname': '广东省',\n",
      "           'poiweight': [],\n",
      "           'shopid': [],\n",
      "           'shopinfo': '2',\n",
      "           'tel': [],\n",
      "           'type': '风景名胜;公园广场;植物园',\n",
      "           'typecode': '110103'}],\n",
      " 'status': '1',\n",
      " 'suggestion': {'cities': [], 'keywords': []}}\n"
     ]
    }
   ],
   "source": [
    "# 检视结果 方式C\n",
    "from pprint import pprint\n",
    "pprint(data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 5,
   "metadata": {},
   "outputs": [
    {
     "name": "stdout",
     "output_type": "stream",
     "text": [
      "20\n",
      "193\n"
     ]
    }
   ],
   "source": [
    "# 结果长度和应该长度之比较\n",
    "print (len(data['pois']))     #API此次返回之结果实质数量\n",
    "print (data['count']) #API返回之结果数量"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 6,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "# 简化代码：你能解释吗？\n",
    "import requests \n",
    "parameters = {'key': '你自己申請到的key'} \n",
    "parameters.update( {'keywords': '植物园',\n",
    "                    'city':     '440000',\n",
    "                    'citylimit': True\n",
    "                   } )\n",
    "\n",
    "r = requests.get (\"http://restapi.amap.com/v3/place/text\", params=parameters)\n",
    "data = r.json()"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 2. 多次返回数据以达应有的实质数量\n",
    "- 关键在於使用 amap api/search 之可选参数 page 当前页数   最大翻页数100\n",
    "- 使用迭代，建构最终结果列表pois，一次一次填20，填满之"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 7,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import requests #用於API HTTP requests\n",
    "parameters = {'key': '你自己申請到的key'}  # 高德地图API 获取Key\n",
    "parameters.update( {'keywords': '植物园',\n",
    "                    'city':     '440000',\n",
    "                    'citylimit': True\n",
    "                   } )\n",
    "\n",
    "pois = []   # 建构最终结果列表pois\n",
    "pg_no = 1   # 建构pg_no，每次给不一样的可选参数page值\n",
    "\n",
    "while True: # 不断迭代，直到 break跳出\n",
    "    parameters.update({'page':pg_no})  #建构可选参数page值 为 pg_no\n",
    "\n",
    "    r = requests.get (\"http://restapi.amap.com/v3/place/text\", params=parameters)\n",
    "    data = r.json()\n",
    "\n",
    "    pois.extend(data['pois'])         # 使用Python列表之extend方法，把返回数据中的结果data['pois']存入pois\n",
    "\n",
    "    \n",
    "    no_pois_this_search = len(pois)   # 计算 累积实质结果数\n",
    "    no_pois = int(data['count'])      # 计算 应有的实质数量\n",
    "\n",
    "\n",
    "    if (no_pois_this_search >= no_pois):  # 若 累积实质结果数 >= 应有的实质数量\n",
    "        break                                   # 则结束迭代跳出\n",
    "    else:\n",
    "        pg_no +=1                               # 否则找下一页数据，把 pg_no增1\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 8,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "193"
      ]
     },
     "execution_count": 8,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 检查pois长度是否有达标\n",
    "len(pois)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## 3. 使用pandas 模块处理及输出数据"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 9,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "df_input = pd.DataFrame(pois)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 10,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>address</th>\n",
       "      <th>adname</th>\n",
       "      <th>biz_ext</th>\n",
       "      <th>biz_type</th>\n",
       "      <th>cityname</th>\n",
       "      <th>distance</th>\n",
       "      <th>id</th>\n",
       "      <th>importance</th>\n",
       "      <th>location</th>\n",
       "      <th>name</th>\n",
       "      <th>pname</th>\n",
       "      <th>poiweight</th>\n",
       "      <th>shopid</th>\n",
       "      <th>shopinfo</th>\n",
       "      <th>tel</th>\n",
       "      <th>type</th>\n",
       "      <th>typecode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>天源路1190号</td>\n",
       "      <td>天河区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00140UEO5</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.367196,23.181797</td>\n",
       "      <td>华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>020-85231993;020-85232037</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>仙湖路160号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F37T4NJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.174956,22.578596</td>\n",
       "      <td>深圳仙湖植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0755-25738430;0755-25722184</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>健民路328号</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F4000E1</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.52128,22.29402</td>\n",
       "      <td>农科奇观</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0756-8535999;0756-8535888</td>\n",
       "      <td>风景名胜;风景名胜;国家级景点</td>\n",
       "      <td>110202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>湖秀新村1号(近湖光岩)</td>\n",
       "      <td>麻章区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F701056</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.275886,21.168908</td>\n",
       "      <td>南亚热带植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0759-2859145;12301</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>新港大道</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00140UFWZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.620092,22.628194</td>\n",
       "      <td>百万葵园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>020-84956360;020-83309917;020-84956863</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>月亮湾青青路1号</td>\n",
       "      <td>南山区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F30242B</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.900516,22.500264</td>\n",
       "      <td>月亮湾公园-青青世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0755-26403988;0755-26646988;0755-26737330</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>和二一路32号</td>\n",
       "      <td>宝安区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F37VJA4</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.770048,22.726385</td>\n",
       "      <td>海上田园-趣味植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>广益街道官湖开发区</td>\n",
       "      <td>澄海区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F2008RH</td>\n",
       "      <td>[]</td>\n",
       "      <td>116.756359,23.502012</td>\n",
       "      <td>科隆千树园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0754-85858327;0754-86985976</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>体育南路近体育馆</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F70NY85</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.389479,21.251218</td>\n",
       "      <td>南国热带花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0759-3480019</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>海湾大桥旁</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F701S9V</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.409452,21.243933</td>\n",
       "      <td>中澳友谊花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>城郊街西和村</td>\n",
       "      <td>从化区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141ICC6</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.583777,23.623854</td>\n",
       "      <td>宝趣玫瑰世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>020-87907777</td>\n",
       "      <td>风景名胜;风景名胜;省级景点</td>\n",
       "      <td>110203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>古镇海洲东岸北路396号</td>\n",
       "      <td>中山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>中山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F80OWVE</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.199458,22.654432</td>\n",
       "      <td>南方绿博园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>325国道旁</td>\n",
       "      <td>电白区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B029C026TX</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.906533,21.455614</td>\n",
       "      <td>茂名市珍稀植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0668-2699020</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>东湖公园</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38I7NS</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.147043,22.563770</td>\n",
       "      <td>东湖公园-杜鹃园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>逸仙路君华新城附近</td>\n",
       "      <td>中山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>中山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F80OXEE</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.480887,22.539581</td>\n",
       "      <td>华佗山公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>G15沈海高速出口</td>\n",
       "      <td>徐闻县</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F701R7Y</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.140605,20.382517</td>\n",
       "      <td>中国科学院华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>323国道附近</td>\n",
       "      <td>仁化县</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02EF0IAI5</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.819593,24.960177</td>\n",
       "      <td>丹霞山灵溪河森林公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0751-6977261;0751-6291683</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>花山镇铁山村</td>\n",
       "      <td>花都区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141K7U7</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.26085,23.464305</td>\n",
       "      <td>香草世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>020-66609112;020-66609118</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>新会劳动大学附近</td>\n",
       "      <td>新会区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>江门市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02EE01Q23</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.036400,22.549087</td>\n",
       "      <td>圭峰山风景名胜区-圭峰植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>马岗岭街67号</td>\n",
       "      <td>白云区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141JAZ8</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.256478,23.267326</td>\n",
       "      <td>石马桃花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>287省道</td>\n",
       "      <td>廉江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F7026HL</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.273411,21.567004</td>\n",
       "      <td>廉江植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>绿色路99号</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFBDUBN</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.747687,22.967355</td>\n",
       "      <td>东莞植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0769-22985736;0769-27380708</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>翠珠路东200米</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHHHXX6</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.007608,22.962757</td>\n",
       "      <td>常平农业科普园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>南湖路与森林大道交叉口北100米</td>\n",
       "      <td>三水区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>佛山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F503M7E</td>\n",
       "      <td>[]</td>\n",
       "      <td>112.877754,23.188254</td>\n",
       "      <td>三水森林公园-孔圣园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0757-87821060;0757-87820806</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>东湖二路21号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38OY0F</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.150001,22.565604</td>\n",
       "      <td>东湖公园-观赏花木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>沿河北路布心路出口附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38OY09</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.147004,22.557208</td>\n",
       "      <td>东湖公园-棕榈园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>东湖二路12号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38OY04</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.148105,22.563978</td>\n",
       "      <td>东湖公园-树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>东湖二路附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38OXXP</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.150001,22.565105</td>\n",
       "      <td>东湖公园-古树区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>南环路与永安一路交汇处</td>\n",
       "      <td>中山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>中山市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F80P8XC</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.369492,22.4894</td>\n",
       "      <td>中山市树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0760-89886985</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>新韶镇东山村</td>\n",
       "      <td>浈江区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFF00PVD</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.672178,24.805628</td>\n",
       "      <td>韶关樱花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>麻礼沙村山海经花海</td>\n",
       "      <td>江城区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>阳江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGH195I</td>\n",
       "      <td>[]</td>\n",
       "      <td>111.881159,21.635098</td>\n",
       "      <td>山海经农业大观园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>0662-3855388</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>东环路与长江路交叉口东南100米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHRW1CG</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.489325,22.960797</td>\n",
       "      <td>萌萌多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>侨城东路深南大道8002号深圳国际园林花卉博览园内</td>\n",
       "      <td>福田区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38SQZQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.008157,22.540220</td>\n",
       "      <td>深圳国际园林花卉博览园-滙芳园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>242省道西50米</td>\n",
       "      <td>城区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>汕尾市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFG7SL6H</td>\n",
       "      <td>[]</td>\n",
       "      <td>115.345690,22.864822</td>\n",
       "      <td>鸿园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>环市东路465号西座</td>\n",
       "      <td>越秀区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGSJ62C</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.299970,23.134819</td>\n",
       "      <td>啊咪要出去玩了</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>18819456794</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFG2CYJP</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.521401,22.291602</td>\n",
       "      <td>农科奇观-蝴蝶兰生产区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>横岗安良安兴路64号</td>\n",
       "      <td>龙岗区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGJMI4P</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.227049,22.635539</td>\n",
       "      <td>慕兰萃植物养肤馆</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>小谷围街道广东科学中心</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFH0CZHP</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.359600,23.037920</td>\n",
       "      <td>广东科学中心-岭南佳果园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>东兴路306号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHC9SZN</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.385399,22.929552</td>\n",
       "      <td>肉嘟嘟多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>15820272570</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>大学城中八路西200米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFG0FIGG</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.406543,23.035617</td>\n",
       "      <td>岭南印象园-乡居田园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>[]</td>\n",
       "      <td>白云区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFIJYK5I</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.264053,23.260056</td>\n",
       "      <td>石马桃花种植场</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>S347(瑜家农庄旁)</td>\n",
       "      <td>新丰县</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFH5L8K9</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.028122,24.047526</td>\n",
       "      <td>潘家寨原生态农业观光园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>城郊街西和村1队</td>\n",
       "      <td>从化区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141OTQ3</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.592358,23.627597</td>\n",
       "      <td>天适樱花悠乐园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>020-37941188</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>中华大街与金华路交叉口东南150米</td>\n",
       "      <td>花都区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141IBJF</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.191648,23.386573</td>\n",
       "      <td>资政园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>北环大道1001号</td>\n",
       "      <td>福田区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38OY0O</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.078000,22.562707</td>\n",
       "      <td>笔架山公园-白千层树林</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室</td>\n",
       "      <td>天河区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFXETSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.363991,23.181380</td>\n",
       "      <td>华南植物园-河谷雨林区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>下里南路东50米</td>\n",
       "      <td>电白区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFH3Z593</td>\n",
       "      <td>[]</td>\n",
       "      <td>111.026469,21.463283</td>\n",
       "      <td>九珠教学示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>广湛公路南50米</td>\n",
       "      <td>吴川市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F700SW3</td>\n",
       "      <td>[]</td>\n",
       "      <td>110.851024,21.432936</td>\n",
       "      <td>华南农科园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>谷饶镇华里乡</td>\n",
       "      <td>潮阳区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFABVSG</td>\n",
       "      <td>[]</td>\n",
       "      <td>116.410734,23.348306</td>\n",
       "      <td>雅香植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>清流村十七队观龙岛</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFHDKCF6</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.484751,22.904370</td>\n",
       "      <td>胧月多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>东部华侨城</td>\n",
       "      <td>盐田区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFDOJ09</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.279906,22.638547</td>\n",
       "      <td>东部华侨城-三洲茶园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>爱国路</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B02F38OY0G</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.146000,22.563602</td>\n",
       "      <td>东湖公园-花圃</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>天源路1190号华南植物园内</td>\n",
       "      <td>天河区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B00141U8UM</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.366521,23.187930</td>\n",
       "      <td>华南植物园-孑遗植物区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>[]</td>\n",
       "      <td>从化区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFI7869U</td>\n",
       "      <td>[]</td>\n",
       "      <td>114.001425,23.803479</td>\n",
       "      <td>桂峰石斛博览园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>科普路168号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFG1RB78</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.361881,23.037000</td>\n",
       "      <td>珍稀濒危植物</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFF2CMPZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.520411,22.290238</td>\n",
       "      <td>农科奇观-树状作物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>万顷沙镇新垦15涌半百万葵园内</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFF6B90</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.621186,22.629145</td>\n",
       "      <td>百万葵园-薰衣草伊甸园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFF2WB6C</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.521023,22.292135</td>\n",
       "      <td>农科奇观-沙漠植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>新港西路135号中山大学南校区</td>\n",
       "      <td>海珠区</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>广州市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFFDBSP6</td>\n",
       "      <td>[]</td>\n",
       "      <td>113.295619,23.094005</td>\n",
       "      <td>中山大学广州南校区竹种标本园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>324国道南50米</td>\n",
       "      <td>罗定市</td>\n",
       "      <td>[]</td>\n",
       "      <td>tour</td>\n",
       "      <td>云浮市</td>\n",
       "      <td>[]</td>\n",
       "      <td>B0FFGAHVMI</td>\n",
       "      <td>[]</td>\n",
       "      <td>111.777369,22.743343</td>\n",
       "      <td>罗定市海惠生态农业观光示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>[]</td>\n",
       "      <td>2</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 17 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                             address adname biz_ext biz_type cityname  \\\n",
       "0                           天源路1190号    天河区      []     tour      广州市   \n",
       "1                            仙湖路160号    罗湖区      []     tour      深圳市   \n",
       "2                            健民路328号    香洲区      []     tour      珠海市   \n",
       "3                       湖秀新村1号(近湖光岩)    麻章区      []     tour      湛江市   \n",
       "4                               新港大道    南沙区      []     tour      广州市   \n",
       "5                           月亮湾青青路1号    南山区      []     tour      深圳市   \n",
       "6                            和二一路32号    宝安区      []     tour      深圳市   \n",
       "7                          广益街道官湖开发区    澄海区      []     tour      汕头市   \n",
       "8                           体育南路近体育馆    赤坎区      []     tour      湛江市   \n",
       "9                              海湾大桥旁    赤坎区      []     tour      湛江市   \n",
       "10                            城郊街西和村    从化区      []     tour      广州市   \n",
       "11                      古镇海洲东岸北路396号    中山市      []     tour      中山市   \n",
       "12                            325国道旁    电白区      []     tour      茂名市   \n",
       "13                              东湖公园    罗湖区      []     tour      深圳市   \n",
       "14                         逸仙路君华新城附近    中山市      []     tour      中山市   \n",
       "15                         G15沈海高速出口    徐闻县      []     tour      湛江市   \n",
       "16                           323国道附近    仁化县      []     tour      韶关市   \n",
       "17                            花山镇铁山村    花都区      []     tour      广州市   \n",
       "18                          新会劳动大学附近    新会区      []     tour      江门市   \n",
       "19                           马岗岭街67号    白云区      []     tour      广州市   \n",
       "20                             287省道    廉江市      []     tour      湛江市   \n",
       "21                            绿色路99号    东莞市      []     tour      东莞市   \n",
       "22                          翠珠路东200米    东莞市      []     tour      东莞市   \n",
       "23                  南湖路与森林大道交叉口北100米    三水区      []     tour      佛山市   \n",
       "24                           东湖二路21号    罗湖区      []     tour      深圳市   \n",
       "25                       沿河北路布心路出口附近    罗湖区      []     tour      深圳市   \n",
       "26                           东湖二路12号    罗湖区      []     tour      深圳市   \n",
       "27                            东湖二路附近    罗湖区      []     tour      深圳市   \n",
       "28                       南环路与永安一路交汇处    中山市      []     tour      中山市   \n",
       "29                            新韶镇东山村    浈江区      []     tour      韶关市   \n",
       "..                               ...    ...     ...      ...      ...   \n",
       "163                        麻礼沙村山海经花海    江城区      []     tour      阳江市   \n",
       "164                 东环路与长江路交叉口东南100米    番禺区      []     tour      广州市   \n",
       "165        侨城东路深南大道8002号深圳国际园林花卉博览园内    福田区      []     tour      深圳市   \n",
       "166                        242省道西50米     城区      []     tour      汕尾市   \n",
       "167                       环市东路465号西座    越秀区      []     tour      广州市   \n",
       "168                    旅游路2428号农科奇观内    香洲区      []     tour      珠海市   \n",
       "169                       横岗安良安兴路64号    龙岗区      []     tour      深圳市   \n",
       "170                      小谷围街道广东科学中心    番禺区      []     tour      广州市   \n",
       "171                          东兴路306号    番禺区      []     tour      广州市   \n",
       "172                      大学城中八路西200米    番禺区      []     tour      广州市   \n",
       "173                               []    白云区      []     tour      广州市   \n",
       "174                      S347(瑜家农庄旁)    新丰县      []     tour      韶关市   \n",
       "175                         城郊街西和村1队    从化区      []     tour      广州市   \n",
       "176                中华大街与金华路交叉口东南150米    花都区      []     tour      广州市   \n",
       "177                        北环大道1001号    福田区      []     tour      深圳市   \n",
       "178  天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室    天河区      []     tour      广州市   \n",
       "179                         下里南路东50米    电白区      []     tour      茂名市   \n",
       "180                         广湛公路南50米    吴川市      []     tour      湛江市   \n",
       "181                           谷饶镇华里乡    潮阳区      []     tour      汕头市   \n",
       "182                        清流村十七队观龙岛    番禺区      []     tour      广州市   \n",
       "183                            东部华侨城    盐田区      []     tour      深圳市   \n",
       "184                              爱国路    罗湖区      []     tour      深圳市   \n",
       "185                   天源路1190号华南植物园内    天河区      []     tour      广州市   \n",
       "186                               []    从化区      []     tour      广州市   \n",
       "187                          科普路168号    番禺区      []     tour      广州市   \n",
       "188                    旅游路2428号农科奇观内    香洲区      []     tour      珠海市   \n",
       "189                  万顷沙镇新垦15涌半百万葵园内    南沙区      []     tour      广州市   \n",
       "190                    旅游路2428号农科奇观内    香洲区      []     tour      珠海市   \n",
       "191                  新港西路135号中山大学南校区    海珠区      []     tour      广州市   \n",
       "192                        324国道南50米    罗定市      []     tour      云浮市   \n",
       "\n",
       "    distance          id importance              location             name  \\\n",
       "0         []  B00140UEO5         []  113.367196,23.181797            华南植物园   \n",
       "1         []  B02F37T4NJ         []  114.174956,22.578596          深圳仙湖植物园   \n",
       "2         []  B02F4000E1         []    113.52128,22.29402             农科奇观   \n",
       "3         []  B02F701056         []  110.275886,21.168908          南亚热带植物园   \n",
       "4         []  B00140UFWZ         []  113.620092,22.628194             百万葵园   \n",
       "5         []  B02F30242B         []  113.900516,22.500264       月亮湾公园-青青世界   \n",
       "6         []  B02F37VJA4         []  113.770048,22.726385       海上田园-趣味植物园   \n",
       "7         []  B02F2008RH         []  116.756359,23.502012            科隆千树园   \n",
       "8         []  B02F70NY85         []  110.389479,21.251218           南国热带花园   \n",
       "9         []  B02F701S9V         []  110.409452,21.243933           中澳友谊花园   \n",
       "10        []  B00141ICC6         []  113.583777,23.623854           宝趣玫瑰世界   \n",
       "11        []  B02F80OWVE         []  113.199458,22.654432            南方绿博园   \n",
       "12        []  B029C026TX         []  110.906533,21.455614         茂名市珍稀植物园   \n",
       "13        []  B02F38I7NS         []  114.147043,22.563770         东湖公园-杜鹃园   \n",
       "14        []  B02F80OXEE         []  113.480887,22.539581            华佗山公园   \n",
       "15        []  B02F701R7Y         []  110.140605,20.382517       中国科学院华南植物园   \n",
       "16        []  B02EF0IAI5         []  113.819593,24.960177       丹霞山灵溪河森林公园   \n",
       "17        []  B00141K7U7         []   113.26085,23.464305             香草世界   \n",
       "18        []  B02EE01Q23         []  113.036400,22.549087   圭峰山风景名胜区-圭峰植物园   \n",
       "19        []  B00141JAZ8         []  113.256478,23.267326           石马桃花公园   \n",
       "20        []  B02F7026HL         []  110.273411,21.567004            廉江植物园   \n",
       "21        []  B0FFFBDUBN         []  113.747687,22.967355            东莞植物园   \n",
       "22        []  B0FFHHHXX6         []  114.007608,22.962757          常平农业科普园   \n",
       "23        []  B02F503M7E         []  112.877754,23.188254       三水森林公园-孔圣园   \n",
       "24        []  B02F38OY0F         []  114.150001,22.565604       东湖公园-观赏花木园   \n",
       "25        []  B02F38OY09         []  114.147004,22.557208         东湖公园-棕榈园   \n",
       "26        []  B02F38OY04         []  114.148105,22.563978         东湖公园-树木园   \n",
       "27        []  B02F38OXXP         []  114.150001,22.565105         东湖公园-古树区   \n",
       "28        []  B02F80P8XC         []    113.369492,22.4894           中山市树木园   \n",
       "29        []  B0FFF00PVD         []  113.672178,24.805628           韶关樱花公园   \n",
       "..       ...         ...        ...                   ...              ...   \n",
       "163       []  B0FFGH195I         []  111.881159,21.635098         山海经农业大观园   \n",
       "164       []  B0FFHRW1CG         []  113.489325,22.960797          萌萌多肉植物园   \n",
       "165       []  B02F38SQZQ         []  114.008157,22.540220  深圳国际园林花卉博览园-滙芳园   \n",
       "166       []  B0FFG7SL6H         []  115.345690,22.864822               鸿园   \n",
       "167       []  B0FFGSJ62C         []  113.299970,23.134819          啊咪要出去玩了   \n",
       "168       []  B0FFG2CYJP         []  113.521401,22.291602      农科奇观-蝴蝶兰生产区   \n",
       "169       []  B0FFGJMI4P         []  114.227049,22.635539         慕兰萃植物养肤馆   \n",
       "170       []  B0FFH0CZHP         []  113.359600,23.037920     广东科学中心-岭南佳果园   \n",
       "171       []  B0FFHC9SZN         []  113.385399,22.929552         肉嘟嘟多肉植物园   \n",
       "172       []  B0FFG0FIGG         []  113.406543,23.035617       岭南印象园-乡居田园   \n",
       "173       []  B0FFIJYK5I         []  113.264053,23.260056          石马桃花种植场   \n",
       "174       []  B0FFH5L8K9         []  114.028122,24.047526      潘家寨原生态农业观光园   \n",
       "175       []  B00141OTQ3         []  113.592358,23.627597          天适樱花悠乐园   \n",
       "176       []  B00141IBJF         []  113.191648,23.386573              资政园   \n",
       "177       []  B02F38OY0O         []  114.078000,22.562707      笔架山公园-白千层树林   \n",
       "178       []  B0FFFXETSP         []  113.363991,23.181380      华南植物园-河谷雨林区   \n",
       "179       []  B0FFH3Z593         []  111.026469,21.463283          九珠教学示范园   \n",
       "180       []  B02F700SW3         []  110.851024,21.432936            华南农科园   \n",
       "181       []  B0FFFABVSG         []  116.410734,23.348306            雅香植物园   \n",
       "182       []  B0FFHDKCF6         []  113.484751,22.904370          胧月多肉植物园   \n",
       "183       []  B0FFFDOJ09         []  114.279906,22.638547       东部华侨城-三洲茶园   \n",
       "184       []  B02F38OY0G         []  114.146000,22.563602          东湖公园-花圃   \n",
       "185       []  B00141U8UM         []  113.366521,23.187930      华南植物园-孑遗植物区   \n",
       "186       []  B0FFI7869U         []  114.001425,23.803479          桂峰石斛博览园   \n",
       "187       []  B0FFG1RB78         []  113.361881,23.037000           珍稀濒危植物   \n",
       "188       []  B0FFF2CMPZ         []  113.520411,22.290238       农科奇观-树状作物园   \n",
       "189       []  B0FFFF6B90         []  113.621186,22.629145      百万葵园-薰衣草伊甸园   \n",
       "190       []  B0FFF2WB6C         []  113.521023,22.292135       农科奇观-沙漠植物园   \n",
       "191       []  B0FFFDBSP6         []  113.295619,23.094005   中山大学广州南校区竹种标本园   \n",
       "192       []  B0FFGAHVMI         []  111.777369,22.743343   罗定市海惠生态农业观光示范园   \n",
       "\n",
       "    pname poiweight shopid shopinfo  \\\n",
       "0     广东省        []     []        2   \n",
       "1     广东省        []     []        2   \n",
       "2     广东省        []     []        2   \n",
       "3     广东省        []     []        2   \n",
       "4     广东省        []     []        2   \n",
       "5     广东省        []     []        2   \n",
       "6     广东省        []     []        2   \n",
       "7     广东省        []     []        2   \n",
       "8     广东省        []     []        2   \n",
       "9     广东省        []     []        2   \n",
       "10    广东省        []     []        2   \n",
       "11    广东省        []     []        2   \n",
       "12    广东省        []     []        2   \n",
       "13    广东省        []     []        2   \n",
       "14    广东省        []     []        2   \n",
       "15    广东省        []     []        2   \n",
       "16    广东省        []     []        2   \n",
       "17    广东省        []     []        2   \n",
       "18    广东省        []     []        2   \n",
       "19    广东省        []     []        2   \n",
       "20    广东省        []     []        2   \n",
       "21    广东省        []     []        2   \n",
       "22    广东省        []     []        2   \n",
       "23    广东省        []     []        2   \n",
       "24    广东省        []     []        2   \n",
       "25    广东省        []     []        2   \n",
       "26    广东省        []     []        2   \n",
       "27    广东省        []     []        2   \n",
       "28    广东省        []     []        2   \n",
       "29    广东省        []     []        2   \n",
       "..    ...       ...    ...      ...   \n",
       "163   广东省        []     []        2   \n",
       "164   广东省        []     []        2   \n",
       "165   广东省        []     []        2   \n",
       "166   广东省        []     []        2   \n",
       "167   广东省        []     []        2   \n",
       "168   广东省        []     []        2   \n",
       "169   广东省        []     []        2   \n",
       "170   广东省        []     []        2   \n",
       "171   广东省        []     []        2   \n",
       "172   广东省        []     []        2   \n",
       "173   广东省        []     []        2   \n",
       "174   广东省        []     []        2   \n",
       "175   广东省        []     []        2   \n",
       "176   广东省        []     []        2   \n",
       "177   广东省        []     []        2   \n",
       "178   广东省        []     []        2   \n",
       "179   广东省        []     []        2   \n",
       "180   广东省        []     []        2   \n",
       "181   广东省        []     []        2   \n",
       "182   广东省        []     []        2   \n",
       "183   广东省        []     []        2   \n",
       "184   广东省        []     []        2   \n",
       "185   广东省        []     []        2   \n",
       "186   广东省        []     []        2   \n",
       "187   广东省        []     []        2   \n",
       "188   广东省        []     []        2   \n",
       "189   广东省        []     []        2   \n",
       "190   广东省        []     []        2   \n",
       "191   广东省        []     []        2   \n",
       "192   广东省        []     []        2   \n",
       "\n",
       "                                           tel              type typecode  \n",
       "0                    020-85231993;020-85232037     风景名胜;公园广场;植物园   110103  \n",
       "1                  0755-25738430;0755-25722184     风景名胜;公园广场;植物园   110103  \n",
       "2                    0756-8535999;0756-8535888   风景名胜;风景名胜;国家级景点   110202  \n",
       "3                           0759-2859145;12301     风景名胜;公园广场;植物园   110103  \n",
       "4       020-84956360;020-83309917;020-84956863      风景名胜;公园广场;公园   110101  \n",
       "5    0755-26403988;0755-26646988;0755-26737330    风景名胜;风景名胜;风景名胜   110200  \n",
       "6                                           []    风景名胜;风景名胜;风景名胜   110200  \n",
       "7                  0754-85858327;0754-86985976     风景名胜;公园广场;植物园   110103  \n",
       "8                                 0759-3480019      风景名胜;公园广场;公园   110101  \n",
       "9                                           []      风景名胜;公园广场;公园   110101  \n",
       "10                                020-87907777    风景名胜;风景名胜;省级景点   110203  \n",
       "11                                          []    风景名胜;风景名胜;风景名胜   110200  \n",
       "12                                0668-2699020     风景名胜;公园广场;植物园   110103  \n",
       "13                                          []      风景名胜;公园广场;公园   110101  \n",
       "14                                          []      风景名胜;公园广场;公园   110101  \n",
       "15                                          []     风景名胜;公园广场;植物园   110103  \n",
       "16                   0751-6977261;0751-6291683    风景名胜;风景名胜;风景名胜   110200  \n",
       "17                   020-66609112;020-66609118  风景名胜;风景名胜相关;旅游景点   110000  \n",
       "18                                          []     风景名胜;公园广场;植物园   110103  \n",
       "19                                          []     风景名胜;公园广场;植物园   110103  \n",
       "20                                          []     风景名胜;公园广场;植物园   110103  \n",
       "21                 0769-22985736;0769-27380708     风景名胜;公园广场;植物园   110103  \n",
       "22                                          []      风景名胜;公园广场;公园   110101  \n",
       "23                 0757-87821060;0757-87820806    风景名胜;风景名胜;风景名胜   110200  \n",
       "24                                          []     风景名胜;公园广场;植物园   110103  \n",
       "25                                          []     风景名胜;公园广场;植物园   110103  \n",
       "26                                          []     风景名胜;公园广场;植物园   110103  \n",
       "27                                          []     风景名胜;公园广场;植物园   110103  \n",
       "28                               0760-89886985     风景名胜;公园广场;植物园   110103  \n",
       "29                                          []      风景名胜;公园广场;公园   110101  \n",
       "..                                         ...               ...      ...  \n",
       "163                               0662-3855388  风景名胜;风景名胜相关;旅游景点   110000  \n",
       "164                                         []     风景名胜;公园广场;植物园   110103  \n",
       "165                                         []  风景名胜;风景名胜相关;旅游景点   110000  \n",
       "166                                         []     风景名胜;公园广场;植物园   110103  \n",
       "167                                18819456794     风景名胜;公园广场;植物园   110103  \n",
       "168                                         []     风景名胜;公园广场;植物园   110103  \n",
       "169                                         []     风景名胜;公园广场;植物园   110103  \n",
       "170                                         []     风景名胜;公园广场;植物园   110103  \n",
       "171                                15820272570     风景名胜;公园广场;植物园   110103  \n",
       "172                                         []    风景名胜;风景名胜;风景名胜   110200  \n",
       "173                                         []     风景名胜;公园广场;植物园   110103  \n",
       "174                                         []     风景名胜;公园广场;植物园   110103  \n",
       "175                               020-37941188    风景名胜;风景名胜;风景名胜   110200  \n",
       "176                                         []     风景名胜;公园广场;植物园   110103  \n",
       "177                                         []     风景名胜;公园广场;植物园   110103  \n",
       "178                                         []     风景名胜;公园广场;植物园   110103  \n",
       "179                                         []     风景名胜;公园广场;植物园   110103  \n",
       "180                                         []     风景名胜;公园广场;植物园   110103  \n",
       "181                                         []     风景名胜;公园广场;植物园   110103  \n",
       "182                                         []     风景名胜;公园广场;植物园   110103  \n",
       "183                                         []    风景名胜;风景名胜;风景名胜   110200  \n",
       "184                                         []     风景名胜;公园广场;植物园   110103  \n",
       "185                                         []    风景名胜;风景名胜;风景名胜   110200  \n",
       "186                                         []     风景名胜;公园广场;植物园   110103  \n",
       "187                                         []     风景名胜;公园广场;植物园   110103  \n",
       "188                                         []     风景名胜;公园广场;植物园   110103  \n",
       "189                                         []     风景名胜;公园广场;植物园   110103  \n",
       "190                                         []     风景名胜;公园广场;植物园   110103  \n",
       "191                                         []     风景名胜;公园广场;植物园   110103  \n",
       "192                                         []     风景名胜;公园广场;植物园   110103  \n",
       "\n",
       "[193 rows x 17 columns]"
      ]
     },
     "execution_count": 10,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df_input"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 11,
   "metadata": {},
   "outputs": [],
   "source": [
    "# 选择部份栏位准备输出\n",
    "select_fields = \"location\taddress\tadname\tcityname\tid\timportance\tname\tpname\ttel\ttype\ttypecode\".split(\"\\t\")\n",
    "df = df_input[select_fields]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 12,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>adname</th>\n",
       "      <th>cityname</th>\n",
       "      <th>id</th>\n",
       "      <th>importance</th>\n",
       "      <th>name</th>\n",
       "      <th>pname</th>\n",
       "      <th>tel</th>\n",
       "      <th>type</th>\n",
       "      <th>typecode</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>113.367196,23.181797</td>\n",
       "      <td>天源路1190号</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00140UEO5</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-85231993;020-85232037</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>114.174956,22.578596</td>\n",
       "      <td>仙湖路160号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F37T4NJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>深圳仙湖植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0755-25738430;0755-25722184</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>113.52128,22.29402</td>\n",
       "      <td>健民路328号</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B02F4000E1</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0756-8535999;0756-8535888</td>\n",
       "      <td>风景名胜;风景名胜;国家级景点</td>\n",
       "      <td>110202</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>110.275886,21.168908</td>\n",
       "      <td>湖秀新村1号(近湖光岩)</td>\n",
       "      <td>麻章区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701056</td>\n",
       "      <td>[]</td>\n",
       "      <td>南亚热带植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0759-2859145;12301</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>113.620092,22.628194</td>\n",
       "      <td>新港大道</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00140UFWZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>百万葵园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-84956360;020-83309917;020-84956863</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>113.900516,22.500264</td>\n",
       "      <td>月亮湾青青路1号</td>\n",
       "      <td>南山区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F30242B</td>\n",
       "      <td>[]</td>\n",
       "      <td>月亮湾公园-青青世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0755-26403988;0755-26646988;0755-26737330</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>113.770048,22.726385</td>\n",
       "      <td>和二一路32号</td>\n",
       "      <td>宝安区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F37VJA4</td>\n",
       "      <td>[]</td>\n",
       "      <td>海上田园-趣味植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>116.756359,23.502012</td>\n",
       "      <td>广益街道官湖开发区</td>\n",
       "      <td>澄海区</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>B02F2008RH</td>\n",
       "      <td>[]</td>\n",
       "      <td>科隆千树园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0754-85858327;0754-86985976</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>110.389479,21.251218</td>\n",
       "      <td>体育南路近体育馆</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F70NY85</td>\n",
       "      <td>[]</td>\n",
       "      <td>南国热带花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0759-3480019</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>110.409452,21.243933</td>\n",
       "      <td>海湾大桥旁</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701S9V</td>\n",
       "      <td>[]</td>\n",
       "      <td>中澳友谊花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>113.583777,23.623854</td>\n",
       "      <td>城郊街西和村</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141ICC6</td>\n",
       "      <td>[]</td>\n",
       "      <td>宝趣玫瑰世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-87907777</td>\n",
       "      <td>风景名胜;风景名胜;省级景点</td>\n",
       "      <td>110203</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>113.199458,22.654432</td>\n",
       "      <td>古镇海洲东岸北路396号</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80OWVE</td>\n",
       "      <td>[]</td>\n",
       "      <td>南方绿博园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>110.906533,21.455614</td>\n",
       "      <td>325国道旁</td>\n",
       "      <td>电白区</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>B029C026TX</td>\n",
       "      <td>[]</td>\n",
       "      <td>茂名市珍稀植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0668-2699020</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>114.147043,22.563770</td>\n",
       "      <td>东湖公园</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38I7NS</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-杜鹃园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>113.480887,22.539581</td>\n",
       "      <td>逸仙路君华新城附近</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80OXEE</td>\n",
       "      <td>[]</td>\n",
       "      <td>华佗山公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>110.140605,20.382517</td>\n",
       "      <td>G15沈海高速出口</td>\n",
       "      <td>徐闻县</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701R7Y</td>\n",
       "      <td>[]</td>\n",
       "      <td>中国科学院华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>113.819593,24.960177</td>\n",
       "      <td>323国道附近</td>\n",
       "      <td>仁化县</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B02EF0IAI5</td>\n",
       "      <td>[]</td>\n",
       "      <td>丹霞山灵溪河森林公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0751-6977261;0751-6291683</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>113.26085,23.464305</td>\n",
       "      <td>花山镇铁山村</td>\n",
       "      <td>花都区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141K7U7</td>\n",
       "      <td>[]</td>\n",
       "      <td>香草世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-66609112;020-66609118</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>113.036400,22.549087</td>\n",
       "      <td>新会劳动大学附近</td>\n",
       "      <td>新会区</td>\n",
       "      <td>江门市</td>\n",
       "      <td>B02EE01Q23</td>\n",
       "      <td>[]</td>\n",
       "      <td>圭峰山风景名胜区-圭峰植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>113.256478,23.267326</td>\n",
       "      <td>马岗岭街67号</td>\n",
       "      <td>白云区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141JAZ8</td>\n",
       "      <td>[]</td>\n",
       "      <td>石马桃花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>110.273411,21.567004</td>\n",
       "      <td>287省道</td>\n",
       "      <td>廉江市</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F7026HL</td>\n",
       "      <td>[]</td>\n",
       "      <td>廉江植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>113.747687,22.967355</td>\n",
       "      <td>绿色路99号</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>B0FFFBDUBN</td>\n",
       "      <td>[]</td>\n",
       "      <td>东莞植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0769-22985736;0769-27380708</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>114.007608,22.962757</td>\n",
       "      <td>翠珠路东200米</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>B0FFHHHXX6</td>\n",
       "      <td>[]</td>\n",
       "      <td>常平农业科普园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>112.877754,23.188254</td>\n",
       "      <td>南湖路与森林大道交叉口北100米</td>\n",
       "      <td>三水区</td>\n",
       "      <td>佛山市</td>\n",
       "      <td>B02F503M7E</td>\n",
       "      <td>[]</td>\n",
       "      <td>三水森林公园-孔圣园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0757-87821060;0757-87820806</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>114.150001,22.565604</td>\n",
       "      <td>东湖二路21号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0F</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-观赏花木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>114.147004,22.557208</td>\n",
       "      <td>沿河北路布心路出口附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY09</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-棕榈园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>114.148105,22.563978</td>\n",
       "      <td>东湖二路12号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY04</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>114.150001,22.565105</td>\n",
       "      <td>东湖二路附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OXXP</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-古树区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>113.369492,22.4894</td>\n",
       "      <td>南环路与永安一路交汇处</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80P8XC</td>\n",
       "      <td>[]</td>\n",
       "      <td>中山市树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0760-89886985</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>113.672178,24.805628</td>\n",
       "      <td>新韶镇东山村</td>\n",
       "      <td>浈江区</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B0FFF00PVD</td>\n",
       "      <td>[]</td>\n",
       "      <td>韶关樱花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>111.881159,21.635098</td>\n",
       "      <td>麻礼沙村山海经花海</td>\n",
       "      <td>江城区</td>\n",
       "      <td>阳江市</td>\n",
       "      <td>B0FFGH195I</td>\n",
       "      <td>[]</td>\n",
       "      <td>山海经农业大观园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0662-3855388</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>113.489325,22.960797</td>\n",
       "      <td>东环路与长江路交叉口东南100米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHRW1CG</td>\n",
       "      <td>[]</td>\n",
       "      <td>萌萌多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>114.008157,22.540220</td>\n",
       "      <td>侨城东路深南大道8002号深圳国际园林花卉博览园内</td>\n",
       "      <td>福田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38SQZQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>深圳国际园林花卉博览园-滙芳园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>115.345690,22.864822</td>\n",
       "      <td>242省道西50米</td>\n",
       "      <td>城区</td>\n",
       "      <td>汕尾市</td>\n",
       "      <td>B0FFG7SL6H</td>\n",
       "      <td>[]</td>\n",
       "      <td>鸿园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>113.299970,23.134819</td>\n",
       "      <td>环市东路465号西座</td>\n",
       "      <td>越秀区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFGSJ62C</td>\n",
       "      <td>[]</td>\n",
       "      <td>啊咪要出去玩了</td>\n",
       "      <td>广东省</td>\n",
       "      <td>18819456794</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>113.521401,22.291602</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFG2CYJP</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-蝴蝶兰生产区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>114.227049,22.635539</td>\n",
       "      <td>横岗安良安兴路64号</td>\n",
       "      <td>龙岗区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B0FFGJMI4P</td>\n",
       "      <td>[]</td>\n",
       "      <td>慕兰萃植物养肤馆</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>113.359600,23.037920</td>\n",
       "      <td>小谷围街道广东科学中心</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFH0CZHP</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东科学中心-岭南佳果园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>113.385399,22.929552</td>\n",
       "      <td>东兴路306号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHC9SZN</td>\n",
       "      <td>[]</td>\n",
       "      <td>肉嘟嘟多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>15820272570</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>113.406543,23.035617</td>\n",
       "      <td>大学城中八路西200米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFG0FIGG</td>\n",
       "      <td>[]</td>\n",
       "      <td>岭南印象园-乡居田园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>113.264053,23.260056</td>\n",
       "      <td>[]</td>\n",
       "      <td>白云区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFIJYK5I</td>\n",
       "      <td>[]</td>\n",
       "      <td>石马桃花种植场</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>114.028122,24.047526</td>\n",
       "      <td>S347(瑜家农庄旁)</td>\n",
       "      <td>新丰县</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B0FFH5L8K9</td>\n",
       "      <td>[]</td>\n",
       "      <td>潘家寨原生态农业观光园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>113.592358,23.627597</td>\n",
       "      <td>城郊街西和村1队</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141OTQ3</td>\n",
       "      <td>[]</td>\n",
       "      <td>天适樱花悠乐园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-37941188</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>113.191648,23.386573</td>\n",
       "      <td>中华大街与金华路交叉口东南150米</td>\n",
       "      <td>花都区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141IBJF</td>\n",
       "      <td>[]</td>\n",
       "      <td>资政园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>114.078000,22.562707</td>\n",
       "      <td>北环大道1001号</td>\n",
       "      <td>福田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0O</td>\n",
       "      <td>[]</td>\n",
       "      <td>笔架山公园-白千层树林</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>113.363991,23.181380</td>\n",
       "      <td>天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFXETSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园-河谷雨林区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>111.026469,21.463283</td>\n",
       "      <td>下里南路东50米</td>\n",
       "      <td>电白区</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>B0FFH3Z593</td>\n",
       "      <td>[]</td>\n",
       "      <td>九珠教学示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>110.851024,21.432936</td>\n",
       "      <td>广湛公路南50米</td>\n",
       "      <td>吴川市</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F700SW3</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南农科园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>116.410734,23.348306</td>\n",
       "      <td>谷饶镇华里乡</td>\n",
       "      <td>潮阳区</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>B0FFFABVSG</td>\n",
       "      <td>[]</td>\n",
       "      <td>雅香植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>113.484751,22.904370</td>\n",
       "      <td>清流村十七队观龙岛</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHDKCF6</td>\n",
       "      <td>[]</td>\n",
       "      <td>胧月多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>114.279906,22.638547</td>\n",
       "      <td>东部华侨城</td>\n",
       "      <td>盐田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B0FFFDOJ09</td>\n",
       "      <td>[]</td>\n",
       "      <td>东部华侨城-三洲茶园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>114.146000,22.563602</td>\n",
       "      <td>爱国路</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0G</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-花圃</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>113.366521,23.187930</td>\n",
       "      <td>天源路1190号华南植物园内</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141U8UM</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园-孑遗植物区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>114.001425,23.803479</td>\n",
       "      <td>[]</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFI7869U</td>\n",
       "      <td>[]</td>\n",
       "      <td>桂峰石斛博览园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>113.361881,23.037000</td>\n",
       "      <td>科普路168号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFG1RB78</td>\n",
       "      <td>[]</td>\n",
       "      <td>珍稀濒危植物</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>113.520411,22.290238</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFF2CMPZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-树状作物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>113.621186,22.629145</td>\n",
       "      <td>万顷沙镇新垦15涌半百万葵园内</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFF6B90</td>\n",
       "      <td>[]</td>\n",
       "      <td>百万葵园-薰衣草伊甸园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>113.521023,22.292135</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFF2WB6C</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-沙漠植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>113.295619,23.094005</td>\n",
       "      <td>新港西路135号中山大学南校区</td>\n",
       "      <td>海珠区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFDBSP6</td>\n",
       "      <td>[]</td>\n",
       "      <td>中山大学广州南校区竹种标本园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>111.777369,22.743343</td>\n",
       "      <td>324国道南50米</td>\n",
       "      <td>罗定市</td>\n",
       "      <td>云浮市</td>\n",
       "      <td>B0FFGAHVMI</td>\n",
       "      <td>[]</td>\n",
       "      <td>罗定市海惠生态农业观光示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 11 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 location                          address adname cityname  \\\n",
       "0    113.367196,23.181797                         天源路1190号    天河区      广州市   \n",
       "1    114.174956,22.578596                          仙湖路160号    罗湖区      深圳市   \n",
       "2      113.52128,22.29402                          健民路328号    香洲区      珠海市   \n",
       "3    110.275886,21.168908                     湖秀新村1号(近湖光岩)    麻章区      湛江市   \n",
       "4    113.620092,22.628194                             新港大道    南沙区      广州市   \n",
       "5    113.900516,22.500264                         月亮湾青青路1号    南山区      深圳市   \n",
       "6    113.770048,22.726385                          和二一路32号    宝安区      深圳市   \n",
       "7    116.756359,23.502012                        广益街道官湖开发区    澄海区      汕头市   \n",
       "8    110.389479,21.251218                         体育南路近体育馆    赤坎区      湛江市   \n",
       "9    110.409452,21.243933                            海湾大桥旁    赤坎区      湛江市   \n",
       "10   113.583777,23.623854                           城郊街西和村    从化区      广州市   \n",
       "11   113.199458,22.654432                     古镇海洲东岸北路396号    中山市      中山市   \n",
       "12   110.906533,21.455614                           325国道旁    电白区      茂名市   \n",
       "13   114.147043,22.563770                             东湖公园    罗湖区      深圳市   \n",
       "14   113.480887,22.539581                        逸仙路君华新城附近    中山市      中山市   \n",
       "15   110.140605,20.382517                        G15沈海高速出口    徐闻县      湛江市   \n",
       "16   113.819593,24.960177                          323国道附近    仁化县      韶关市   \n",
       "17    113.26085,23.464305                           花山镇铁山村    花都区      广州市   \n",
       "18   113.036400,22.549087                         新会劳动大学附近    新会区      江门市   \n",
       "19   113.256478,23.267326                          马岗岭街67号    白云区      广州市   \n",
       "20   110.273411,21.567004                            287省道    廉江市      湛江市   \n",
       "21   113.747687,22.967355                           绿色路99号    东莞市      东莞市   \n",
       "22   114.007608,22.962757                         翠珠路东200米    东莞市      东莞市   \n",
       "23   112.877754,23.188254                 南湖路与森林大道交叉口北100米    三水区      佛山市   \n",
       "24   114.150001,22.565604                          东湖二路21号    罗湖区      深圳市   \n",
       "25   114.147004,22.557208                      沿河北路布心路出口附近    罗湖区      深圳市   \n",
       "26   114.148105,22.563978                          东湖二路12号    罗湖区      深圳市   \n",
       "27   114.150001,22.565105                           东湖二路附近    罗湖区      深圳市   \n",
       "28     113.369492,22.4894                      南环路与永安一路交汇处    中山市      中山市   \n",
       "29   113.672178,24.805628                           新韶镇东山村    浈江区      韶关市   \n",
       "..                    ...                              ...    ...      ...   \n",
       "163  111.881159,21.635098                        麻礼沙村山海经花海    江城区      阳江市   \n",
       "164  113.489325,22.960797                 东环路与长江路交叉口东南100米    番禺区      广州市   \n",
       "165  114.008157,22.540220        侨城东路深南大道8002号深圳国际园林花卉博览园内    福田区      深圳市   \n",
       "166  115.345690,22.864822                        242省道西50米     城区      汕尾市   \n",
       "167  113.299970,23.134819                       环市东路465号西座    越秀区      广州市   \n",
       "168  113.521401,22.291602                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "169  114.227049,22.635539                       横岗安良安兴路64号    龙岗区      深圳市   \n",
       "170  113.359600,23.037920                      小谷围街道广东科学中心    番禺区      广州市   \n",
       "171  113.385399,22.929552                          东兴路306号    番禺区      广州市   \n",
       "172  113.406543,23.035617                      大学城中八路西200米    番禺区      广州市   \n",
       "173  113.264053,23.260056                               []    白云区      广州市   \n",
       "174  114.028122,24.047526                      S347(瑜家农庄旁)    新丰县      韶关市   \n",
       "175  113.592358,23.627597                         城郊街西和村1队    从化区      广州市   \n",
       "176  113.191648,23.386573                中华大街与金华路交叉口东南150米    花都区      广州市   \n",
       "177  114.078000,22.562707                        北环大道1001号    福田区      深圳市   \n",
       "178  113.363991,23.181380  天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室    天河区      广州市   \n",
       "179  111.026469,21.463283                         下里南路东50米    电白区      茂名市   \n",
       "180  110.851024,21.432936                         广湛公路南50米    吴川市      湛江市   \n",
       "181  116.410734,23.348306                           谷饶镇华里乡    潮阳区      汕头市   \n",
       "182  113.484751,22.904370                        清流村十七队观龙岛    番禺区      广州市   \n",
       "183  114.279906,22.638547                            东部华侨城    盐田区      深圳市   \n",
       "184  114.146000,22.563602                              爱国路    罗湖区      深圳市   \n",
       "185  113.366521,23.187930                   天源路1190号华南植物园内    天河区      广州市   \n",
       "186  114.001425,23.803479                               []    从化区      广州市   \n",
       "187  113.361881,23.037000                          科普路168号    番禺区      广州市   \n",
       "188  113.520411,22.290238                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "189  113.621186,22.629145                  万顷沙镇新垦15涌半百万葵园内    南沙区      广州市   \n",
       "190  113.521023,22.292135                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "191  113.295619,23.094005                  新港西路135号中山大学南校区    海珠区      广州市   \n",
       "192  111.777369,22.743343                        324国道南50米    罗定市      云浮市   \n",
       "\n",
       "             id importance             name pname  \\\n",
       "0    B00140UEO5         []            华南植物园   广东省   \n",
       "1    B02F37T4NJ         []          深圳仙湖植物园   广东省   \n",
       "2    B02F4000E1         []             农科奇观   广东省   \n",
       "3    B02F701056         []          南亚热带植物园   广东省   \n",
       "4    B00140UFWZ         []             百万葵园   广东省   \n",
       "5    B02F30242B         []       月亮湾公园-青青世界   广东省   \n",
       "6    B02F37VJA4         []       海上田园-趣味植物园   广东省   \n",
       "7    B02F2008RH         []            科隆千树园   广东省   \n",
       "8    B02F70NY85         []           南国热带花园   广东省   \n",
       "9    B02F701S9V         []           中澳友谊花园   广东省   \n",
       "10   B00141ICC6         []           宝趣玫瑰世界   广东省   \n",
       "11   B02F80OWVE         []            南方绿博园   广东省   \n",
       "12   B029C026TX         []         茂名市珍稀植物园   广东省   \n",
       "13   B02F38I7NS         []         东湖公园-杜鹃园   广东省   \n",
       "14   B02F80OXEE         []            华佗山公园   广东省   \n",
       "15   B02F701R7Y         []       中国科学院华南植物园   广东省   \n",
       "16   B02EF0IAI5         []       丹霞山灵溪河森林公园   广东省   \n",
       "17   B00141K7U7         []             香草世界   广东省   \n",
       "18   B02EE01Q23         []   圭峰山风景名胜区-圭峰植物园   广东省   \n",
       "19   B00141JAZ8         []           石马桃花公园   广东省   \n",
       "20   B02F7026HL         []            廉江植物园   广东省   \n",
       "21   B0FFFBDUBN         []            东莞植物园   广东省   \n",
       "22   B0FFHHHXX6         []          常平农业科普园   广东省   \n",
       "23   B02F503M7E         []       三水森林公园-孔圣园   广东省   \n",
       "24   B02F38OY0F         []       东湖公园-观赏花木园   广东省   \n",
       "25   B02F38OY09         []         东湖公园-棕榈园   广东省   \n",
       "26   B02F38OY04         []         东湖公园-树木园   广东省   \n",
       "27   B02F38OXXP         []         东湖公园-古树区   广东省   \n",
       "28   B02F80P8XC         []           中山市树木园   广东省   \n",
       "29   B0FFF00PVD         []           韶关樱花公园   广东省   \n",
       "..          ...        ...              ...   ...   \n",
       "163  B0FFGH195I         []         山海经农业大观园   广东省   \n",
       "164  B0FFHRW1CG         []          萌萌多肉植物园   广东省   \n",
       "165  B02F38SQZQ         []  深圳国际园林花卉博览园-滙芳园   广东省   \n",
       "166  B0FFG7SL6H         []               鸿园   广东省   \n",
       "167  B0FFGSJ62C         []          啊咪要出去玩了   广东省   \n",
       "168  B0FFG2CYJP         []      农科奇观-蝴蝶兰生产区   广东省   \n",
       "169  B0FFGJMI4P         []         慕兰萃植物养肤馆   广东省   \n",
       "170  B0FFH0CZHP         []     广东科学中心-岭南佳果园   广东省   \n",
       "171  B0FFHC9SZN         []         肉嘟嘟多肉植物园   广东省   \n",
       "172  B0FFG0FIGG         []       岭南印象园-乡居田园   广东省   \n",
       "173  B0FFIJYK5I         []          石马桃花种植场   广东省   \n",
       "174  B0FFH5L8K9         []      潘家寨原生态农业观光园   广东省   \n",
       "175  B00141OTQ3         []          天适樱花悠乐园   广东省   \n",
       "176  B00141IBJF         []              资政园   广东省   \n",
       "177  B02F38OY0O         []      笔架山公园-白千层树林   广东省   \n",
       "178  B0FFFXETSP         []      华南植物园-河谷雨林区   广东省   \n",
       "179  B0FFH3Z593         []          九珠教学示范园   广东省   \n",
       "180  B02F700SW3         []            华南农科园   广东省   \n",
       "181  B0FFFABVSG         []            雅香植物园   广东省   \n",
       "182  B0FFHDKCF6         []          胧月多肉植物园   广东省   \n",
       "183  B0FFFDOJ09         []       东部华侨城-三洲茶园   广东省   \n",
       "184  B02F38OY0G         []          东湖公园-花圃   广东省   \n",
       "185  B00141U8UM         []      华南植物园-孑遗植物区   广东省   \n",
       "186  B0FFI7869U         []          桂峰石斛博览园   广东省   \n",
       "187  B0FFG1RB78         []           珍稀濒危植物   广东省   \n",
       "188  B0FFF2CMPZ         []       农科奇观-树状作物园   广东省   \n",
       "189  B0FFFF6B90         []      百万葵园-薰衣草伊甸园   广东省   \n",
       "190  B0FFF2WB6C         []       农科奇观-沙漠植物园   广东省   \n",
       "191  B0FFFDBSP6         []   中山大学广州南校区竹种标本园   广东省   \n",
       "192  B0FFGAHVMI         []   罗定市海惠生态农业观光示范园   广东省   \n",
       "\n",
       "                                           tel              type typecode  \n",
       "0                    020-85231993;020-85232037     风景名胜;公园广场;植物园   110103  \n",
       "1                  0755-25738430;0755-25722184     风景名胜;公园广场;植物园   110103  \n",
       "2                    0756-8535999;0756-8535888   风景名胜;风景名胜;国家级景点   110202  \n",
       "3                           0759-2859145;12301     风景名胜;公园广场;植物园   110103  \n",
       "4       020-84956360;020-83309917;020-84956863      风景名胜;公园广场;公园   110101  \n",
       "5    0755-26403988;0755-26646988;0755-26737330    风景名胜;风景名胜;风景名胜   110200  \n",
       "6                                           []    风景名胜;风景名胜;风景名胜   110200  \n",
       "7                  0754-85858327;0754-86985976     风景名胜;公园广场;植物园   110103  \n",
       "8                                 0759-3480019      风景名胜;公园广场;公园   110101  \n",
       "9                                           []      风景名胜;公园广场;公园   110101  \n",
       "10                                020-87907777    风景名胜;风景名胜;省级景点   110203  \n",
       "11                                          []    风景名胜;风景名胜;风景名胜   110200  \n",
       "12                                0668-2699020     风景名胜;公园广场;植物园   110103  \n",
       "13                                          []      风景名胜;公园广场;公园   110101  \n",
       "14                                          []      风景名胜;公园广场;公园   110101  \n",
       "15                                          []     风景名胜;公园广场;植物园   110103  \n",
       "16                   0751-6977261;0751-6291683    风景名胜;风景名胜;风景名胜   110200  \n",
       "17                   020-66609112;020-66609118  风景名胜;风景名胜相关;旅游景点   110000  \n",
       "18                                          []     风景名胜;公园广场;植物园   110103  \n",
       "19                                          []     风景名胜;公园广场;植物园   110103  \n",
       "20                                          []     风景名胜;公园广场;植物园   110103  \n",
       "21                 0769-22985736;0769-27380708     风景名胜;公园广场;植物园   110103  \n",
       "22                                          []      风景名胜;公园广场;公园   110101  \n",
       "23                 0757-87821060;0757-87820806    风景名胜;风景名胜;风景名胜   110200  \n",
       "24                                          []     风景名胜;公园广场;植物园   110103  \n",
       "25                                          []     风景名胜;公园广场;植物园   110103  \n",
       "26                                          []     风景名胜;公园广场;植物园   110103  \n",
       "27                                          []     风景名胜;公园广场;植物园   110103  \n",
       "28                               0760-89886985     风景名胜;公园广场;植物园   110103  \n",
       "29                                          []      风景名胜;公园广场;公园   110101  \n",
       "..                                         ...               ...      ...  \n",
       "163                               0662-3855388  风景名胜;风景名胜相关;旅游景点   110000  \n",
       "164                                         []     风景名胜;公园广场;植物园   110103  \n",
       "165                                         []  风景名胜;风景名胜相关;旅游景点   110000  \n",
       "166                                         []     风景名胜;公园广场;植物园   110103  \n",
       "167                                18819456794     风景名胜;公园广场;植物园   110103  \n",
       "168                                         []     风景名胜;公园广场;植物园   110103  \n",
       "169                                         []     风景名胜;公园广场;植物园   110103  \n",
       "170                                         []     风景名胜;公园广场;植物园   110103  \n",
       "171                                15820272570     风景名胜;公园广场;植物园   110103  \n",
       "172                                         []    风景名胜;风景名胜;风景名胜   110200  \n",
       "173                                         []     风景名胜;公园广场;植物园   110103  \n",
       "174                                         []     风景名胜;公园广场;植物园   110103  \n",
       "175                               020-37941188    风景名胜;风景名胜;风景名胜   110200  \n",
       "176                                         []     风景名胜;公园广场;植物园   110103  \n",
       "177                                         []     风景名胜;公园广场;植物园   110103  \n",
       "178                                         []     风景名胜;公园广场;植物园   110103  \n",
       "179                                         []     风景名胜;公园广场;植物园   110103  \n",
       "180                                         []     风景名胜;公园广场;植物园   110103  \n",
       "181                                         []     风景名胜;公园广场;植物园   110103  \n",
       "182                                         []     风景名胜;公园广场;植物园   110103  \n",
       "183                                         []    风景名胜;风景名胜;风景名胜   110200  \n",
       "184                                         []     风景名胜;公园广场;植物园   110103  \n",
       "185                                         []    风景名胜;风景名胜;风景名胜   110200  \n",
       "186                                         []     风景名胜;公园广场;植物园   110103  \n",
       "187                                         []     风景名胜;公园广场;植物园   110103  \n",
       "188                                         []     风景名胜;公园广场;植物园   110103  \n",
       "189                                         []     风景名胜;公园广场;植物园   110103  \n",
       "190                                         []     风景名胜;公园广场;植物园   110103  \n",
       "191                                         []     风景名胜;公园广场;植物园   110103  \n",
       "192                                         []     风景名胜;公园广场;植物园   110103  \n",
       "\n",
       "[193 rows x 11 columns]"
      ]
     },
     "execution_count": 12,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 14,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "193"
      ]
     },
     "execution_count": 14,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "len(df)"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### 经纬度\n",
    "![经纬度](http://www.learner.org/jnorth/images/graphics/mclass/Lat_Long.gif \"Optional title\")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 16,
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>location</th>\n",
       "      <th>address</th>\n",
       "      <th>adname</th>\n",
       "      <th>cityname</th>\n",
       "      <th>id</th>\n",
       "      <th>importance</th>\n",
       "      <th>name</th>\n",
       "      <th>pname</th>\n",
       "      <th>tel</th>\n",
       "      <th>type</th>\n",
       "      <th>typecode</th>\n",
       "      <th>经</th>\n",
       "      <th>纬</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>113.367196,23.181797</td>\n",
       "      <td>天源路1190号</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00140UEO5</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-85231993;020-85232037</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.367196</td>\n",
       "      <td>113.367196</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>114.174956,22.578596</td>\n",
       "      <td>仙湖路160号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F37T4NJ</td>\n",
       "      <td>[]</td>\n",
       "      <td>深圳仙湖植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0755-25738430;0755-25722184</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.174956</td>\n",
       "      <td>114.174956</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>113.52128,22.29402</td>\n",
       "      <td>健民路328号</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B02F4000E1</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0756-8535999;0756-8535888</td>\n",
       "      <td>风景名胜;风景名胜;国家级景点</td>\n",
       "      <td>110202</td>\n",
       "      <td>113.52128</td>\n",
       "      <td>113.52128</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>110.275886,21.168908</td>\n",
       "      <td>湖秀新村1号(近湖光岩)</td>\n",
       "      <td>麻章区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701056</td>\n",
       "      <td>[]</td>\n",
       "      <td>南亚热带植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0759-2859145;12301</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.275886</td>\n",
       "      <td>110.275886</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>113.620092,22.628194</td>\n",
       "      <td>新港大道</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00140UFWZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>百万葵园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-84956360;020-83309917;020-84956863</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>113.620092</td>\n",
       "      <td>113.620092</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5</th>\n",
       "      <td>113.900516,22.500264</td>\n",
       "      <td>月亮湾青青路1号</td>\n",
       "      <td>南山区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F30242B</td>\n",
       "      <td>[]</td>\n",
       "      <td>月亮湾公园-青青世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0755-26403988;0755-26646988;0755-26737330</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.900516</td>\n",
       "      <td>113.900516</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6</th>\n",
       "      <td>113.770048,22.726385</td>\n",
       "      <td>和二一路32号</td>\n",
       "      <td>宝安区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F37VJA4</td>\n",
       "      <td>[]</td>\n",
       "      <td>海上田园-趣味植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.770048</td>\n",
       "      <td>113.770048</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7</th>\n",
       "      <td>116.756359,23.502012</td>\n",
       "      <td>广益街道官湖开发区</td>\n",
       "      <td>澄海区</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>B02F2008RH</td>\n",
       "      <td>[]</td>\n",
       "      <td>科隆千树园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0754-85858327;0754-86985976</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>116.756359</td>\n",
       "      <td>116.756359</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8</th>\n",
       "      <td>110.389479,21.251218</td>\n",
       "      <td>体育南路近体育馆</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F70NY85</td>\n",
       "      <td>[]</td>\n",
       "      <td>南国热带花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0759-3480019</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>110.389479</td>\n",
       "      <td>110.389479</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9</th>\n",
       "      <td>110.409452,21.243933</td>\n",
       "      <td>海湾大桥旁</td>\n",
       "      <td>赤坎区</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701S9V</td>\n",
       "      <td>[]</td>\n",
       "      <td>中澳友谊花园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>110.409452</td>\n",
       "      <td>110.409452</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10</th>\n",
       "      <td>113.583777,23.623854</td>\n",
       "      <td>城郊街西和村</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141ICC6</td>\n",
       "      <td>[]</td>\n",
       "      <td>宝趣玫瑰世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-87907777</td>\n",
       "      <td>风景名胜;风景名胜;省级景点</td>\n",
       "      <td>110203</td>\n",
       "      <td>113.583777</td>\n",
       "      <td>113.583777</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11</th>\n",
       "      <td>113.199458,22.654432</td>\n",
       "      <td>古镇海洲东岸北路396号</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80OWVE</td>\n",
       "      <td>[]</td>\n",
       "      <td>南方绿博园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.199458</td>\n",
       "      <td>113.199458</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12</th>\n",
       "      <td>110.906533,21.455614</td>\n",
       "      <td>325国道旁</td>\n",
       "      <td>电白区</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>B029C026TX</td>\n",
       "      <td>[]</td>\n",
       "      <td>茂名市珍稀植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0668-2699020</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.906533</td>\n",
       "      <td>110.906533</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>13</th>\n",
       "      <td>114.147043,22.563770</td>\n",
       "      <td>东湖公园</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38I7NS</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-杜鹃园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>114.147043</td>\n",
       "      <td>114.147043</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>14</th>\n",
       "      <td>113.480887,22.539581</td>\n",
       "      <td>逸仙路君华新城附近</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80OXEE</td>\n",
       "      <td>[]</td>\n",
       "      <td>华佗山公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>113.480887</td>\n",
       "      <td>113.480887</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>15</th>\n",
       "      <td>110.140605,20.382517</td>\n",
       "      <td>G15沈海高速出口</td>\n",
       "      <td>徐闻县</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F701R7Y</td>\n",
       "      <td>[]</td>\n",
       "      <td>中国科学院华南植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.140605</td>\n",
       "      <td>110.140605</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>16</th>\n",
       "      <td>113.819593,24.960177</td>\n",
       "      <td>323国道附近</td>\n",
       "      <td>仁化县</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B02EF0IAI5</td>\n",
       "      <td>[]</td>\n",
       "      <td>丹霞山灵溪河森林公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0751-6977261;0751-6291683</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.819593</td>\n",
       "      <td>113.819593</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>17</th>\n",
       "      <td>113.26085,23.464305</td>\n",
       "      <td>花山镇铁山村</td>\n",
       "      <td>花都区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141K7U7</td>\n",
       "      <td>[]</td>\n",
       "      <td>香草世界</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-66609112;020-66609118</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "      <td>113.26085</td>\n",
       "      <td>113.26085</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>18</th>\n",
       "      <td>113.036400,22.549087</td>\n",
       "      <td>新会劳动大学附近</td>\n",
       "      <td>新会区</td>\n",
       "      <td>江门市</td>\n",
       "      <td>B02EE01Q23</td>\n",
       "      <td>[]</td>\n",
       "      <td>圭峰山风景名胜区-圭峰植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.036400</td>\n",
       "      <td>113.036400</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>19</th>\n",
       "      <td>113.256478,23.267326</td>\n",
       "      <td>马岗岭街67号</td>\n",
       "      <td>白云区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141JAZ8</td>\n",
       "      <td>[]</td>\n",
       "      <td>石马桃花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.256478</td>\n",
       "      <td>113.256478</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>20</th>\n",
       "      <td>110.273411,21.567004</td>\n",
       "      <td>287省道</td>\n",
       "      <td>廉江市</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F7026HL</td>\n",
       "      <td>[]</td>\n",
       "      <td>廉江植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.273411</td>\n",
       "      <td>110.273411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>21</th>\n",
       "      <td>113.747687,22.967355</td>\n",
       "      <td>绿色路99号</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>B0FFFBDUBN</td>\n",
       "      <td>[]</td>\n",
       "      <td>东莞植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0769-22985736;0769-27380708</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.747687</td>\n",
       "      <td>113.747687</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>22</th>\n",
       "      <td>114.007608,22.962757</td>\n",
       "      <td>翠珠路东200米</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>东莞市</td>\n",
       "      <td>B0FFHHHXX6</td>\n",
       "      <td>[]</td>\n",
       "      <td>常平农业科普园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>114.007608</td>\n",
       "      <td>114.007608</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>23</th>\n",
       "      <td>112.877754,23.188254</td>\n",
       "      <td>南湖路与森林大道交叉口北100米</td>\n",
       "      <td>三水区</td>\n",
       "      <td>佛山市</td>\n",
       "      <td>B02F503M7E</td>\n",
       "      <td>[]</td>\n",
       "      <td>三水森林公园-孔圣园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0757-87821060;0757-87820806</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>112.877754</td>\n",
       "      <td>112.877754</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>24</th>\n",
       "      <td>114.150001,22.565604</td>\n",
       "      <td>东湖二路21号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0F</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-观赏花木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.150001</td>\n",
       "      <td>114.150001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>25</th>\n",
       "      <td>114.147004,22.557208</td>\n",
       "      <td>沿河北路布心路出口附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY09</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-棕榈园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.147004</td>\n",
       "      <td>114.147004</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>26</th>\n",
       "      <td>114.148105,22.563978</td>\n",
       "      <td>东湖二路12号</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY04</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.148105</td>\n",
       "      <td>114.148105</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>27</th>\n",
       "      <td>114.150001,22.565105</td>\n",
       "      <td>东湖二路附近</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OXXP</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-古树区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.150001</td>\n",
       "      <td>114.150001</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>28</th>\n",
       "      <td>113.369492,22.4894</td>\n",
       "      <td>南环路与永安一路交汇处</td>\n",
       "      <td>中山市</td>\n",
       "      <td>中山市</td>\n",
       "      <td>B02F80P8XC</td>\n",
       "      <td>[]</td>\n",
       "      <td>中山市树木园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0760-89886985</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.369492</td>\n",
       "      <td>113.369492</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>29</th>\n",
       "      <td>113.672178,24.805628</td>\n",
       "      <td>新韶镇东山村</td>\n",
       "      <td>浈江区</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B0FFF00PVD</td>\n",
       "      <td>[]</td>\n",
       "      <td>韶关樱花公园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;公园</td>\n",
       "      <td>110101</td>\n",
       "      <td>113.672178</td>\n",
       "      <td>113.672178</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>163</th>\n",
       "      <td>111.881159,21.635098</td>\n",
       "      <td>麻礼沙村山海经花海</td>\n",
       "      <td>江城区</td>\n",
       "      <td>阳江市</td>\n",
       "      <td>B0FFGH195I</td>\n",
       "      <td>[]</td>\n",
       "      <td>山海经农业大观园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>0662-3855388</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "      <td>111.881159</td>\n",
       "      <td>111.881159</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>164</th>\n",
       "      <td>113.489325,22.960797</td>\n",
       "      <td>东环路与长江路交叉口东南100米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHRW1CG</td>\n",
       "      <td>[]</td>\n",
       "      <td>萌萌多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.489325</td>\n",
       "      <td>113.489325</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>165</th>\n",
       "      <td>114.008157,22.540220</td>\n",
       "      <td>侨城东路深南大道8002号深圳国际园林花卉博览园内</td>\n",
       "      <td>福田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38SQZQ</td>\n",
       "      <td>[]</td>\n",
       "      <td>深圳国际园林花卉博览园-滙芳园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜相关;旅游景点</td>\n",
       "      <td>110000</td>\n",
       "      <td>114.008157</td>\n",
       "      <td>114.008157</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>166</th>\n",
       "      <td>115.345690,22.864822</td>\n",
       "      <td>242省道西50米</td>\n",
       "      <td>城区</td>\n",
       "      <td>汕尾市</td>\n",
       "      <td>B0FFG7SL6H</td>\n",
       "      <td>[]</td>\n",
       "      <td>鸿园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>115.345690</td>\n",
       "      <td>115.345690</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>167</th>\n",
       "      <td>113.299970,23.134819</td>\n",
       "      <td>环市东路465号西座</td>\n",
       "      <td>越秀区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFGSJ62C</td>\n",
       "      <td>[]</td>\n",
       "      <td>啊咪要出去玩了</td>\n",
       "      <td>广东省</td>\n",
       "      <td>18819456794</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.299970</td>\n",
       "      <td>113.299970</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>168</th>\n",
       "      <td>113.521401,22.291602</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFG2CYJP</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-蝴蝶兰生产区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.521401</td>\n",
       "      <td>113.521401</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>169</th>\n",
       "      <td>114.227049,22.635539</td>\n",
       "      <td>横岗安良安兴路64号</td>\n",
       "      <td>龙岗区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B0FFGJMI4P</td>\n",
       "      <td>[]</td>\n",
       "      <td>慕兰萃植物养肤馆</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.227049</td>\n",
       "      <td>114.227049</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>170</th>\n",
       "      <td>113.359600,23.037920</td>\n",
       "      <td>小谷围街道广东科学中心</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFH0CZHP</td>\n",
       "      <td>[]</td>\n",
       "      <td>广东科学中心-岭南佳果园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.359600</td>\n",
       "      <td>113.359600</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>171</th>\n",
       "      <td>113.385399,22.929552</td>\n",
       "      <td>东兴路306号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHC9SZN</td>\n",
       "      <td>[]</td>\n",
       "      <td>肉嘟嘟多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>15820272570</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.385399</td>\n",
       "      <td>113.385399</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>172</th>\n",
       "      <td>113.406543,23.035617</td>\n",
       "      <td>大学城中八路西200米</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFG0FIGG</td>\n",
       "      <td>[]</td>\n",
       "      <td>岭南印象园-乡居田园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.406543</td>\n",
       "      <td>113.406543</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>173</th>\n",
       "      <td>113.264053,23.260056</td>\n",
       "      <td>[]</td>\n",
       "      <td>白云区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFIJYK5I</td>\n",
       "      <td>[]</td>\n",
       "      <td>石马桃花种植场</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.264053</td>\n",
       "      <td>113.264053</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>174</th>\n",
       "      <td>114.028122,24.047526</td>\n",
       "      <td>S347(瑜家农庄旁)</td>\n",
       "      <td>新丰县</td>\n",
       "      <td>韶关市</td>\n",
       "      <td>B0FFH5L8K9</td>\n",
       "      <td>[]</td>\n",
       "      <td>潘家寨原生态农业观光园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.028122</td>\n",
       "      <td>114.028122</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>175</th>\n",
       "      <td>113.592358,23.627597</td>\n",
       "      <td>城郊街西和村1队</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141OTQ3</td>\n",
       "      <td>[]</td>\n",
       "      <td>天适樱花悠乐园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>020-37941188</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.592358</td>\n",
       "      <td>113.592358</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>176</th>\n",
       "      <td>113.191648,23.386573</td>\n",
       "      <td>中华大街与金华路交叉口东南150米</td>\n",
       "      <td>花都区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141IBJF</td>\n",
       "      <td>[]</td>\n",
       "      <td>资政园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.191648</td>\n",
       "      <td>113.191648</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>177</th>\n",
       "      <td>114.078000,22.562707</td>\n",
       "      <td>北环大道1001号</td>\n",
       "      <td>福田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0O</td>\n",
       "      <td>[]</td>\n",
       "      <td>笔架山公园-白千层树林</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.078000</td>\n",
       "      <td>114.078000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>178</th>\n",
       "      <td>113.363991,23.181380</td>\n",
       "      <td>天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFXETSP</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园-河谷雨林区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.363991</td>\n",
       "      <td>113.363991</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>179</th>\n",
       "      <td>111.026469,21.463283</td>\n",
       "      <td>下里南路东50米</td>\n",
       "      <td>电白区</td>\n",
       "      <td>茂名市</td>\n",
       "      <td>B0FFH3Z593</td>\n",
       "      <td>[]</td>\n",
       "      <td>九珠教学示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>111.026469</td>\n",
       "      <td>111.026469</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>180</th>\n",
       "      <td>110.851024,21.432936</td>\n",
       "      <td>广湛公路南50米</td>\n",
       "      <td>吴川市</td>\n",
       "      <td>湛江市</td>\n",
       "      <td>B02F700SW3</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南农科园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>110.851024</td>\n",
       "      <td>110.851024</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>181</th>\n",
       "      <td>116.410734,23.348306</td>\n",
       "      <td>谷饶镇华里乡</td>\n",
       "      <td>潮阳区</td>\n",
       "      <td>汕头市</td>\n",
       "      <td>B0FFFABVSG</td>\n",
       "      <td>[]</td>\n",
       "      <td>雅香植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>116.410734</td>\n",
       "      <td>116.410734</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>182</th>\n",
       "      <td>113.484751,22.904370</td>\n",
       "      <td>清流村十七队观龙岛</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFHDKCF6</td>\n",
       "      <td>[]</td>\n",
       "      <td>胧月多肉植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.484751</td>\n",
       "      <td>113.484751</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>183</th>\n",
       "      <td>114.279906,22.638547</td>\n",
       "      <td>东部华侨城</td>\n",
       "      <td>盐田区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B0FFFDOJ09</td>\n",
       "      <td>[]</td>\n",
       "      <td>东部华侨城-三洲茶园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>114.279906</td>\n",
       "      <td>114.279906</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>184</th>\n",
       "      <td>114.146000,22.563602</td>\n",
       "      <td>爱国路</td>\n",
       "      <td>罗湖区</td>\n",
       "      <td>深圳市</td>\n",
       "      <td>B02F38OY0G</td>\n",
       "      <td>[]</td>\n",
       "      <td>东湖公园-花圃</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.146000</td>\n",
       "      <td>114.146000</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>185</th>\n",
       "      <td>113.366521,23.187930</td>\n",
       "      <td>天源路1190号华南植物园内</td>\n",
       "      <td>天河区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B00141U8UM</td>\n",
       "      <td>[]</td>\n",
       "      <td>华南植物园-孑遗植物区</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;风景名胜;风景名胜</td>\n",
       "      <td>110200</td>\n",
       "      <td>113.366521</td>\n",
       "      <td>113.366521</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>186</th>\n",
       "      <td>114.001425,23.803479</td>\n",
       "      <td>[]</td>\n",
       "      <td>从化区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFI7869U</td>\n",
       "      <td>[]</td>\n",
       "      <td>桂峰石斛博览园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>114.001425</td>\n",
       "      <td>114.001425</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>187</th>\n",
       "      <td>113.361881,23.037000</td>\n",
       "      <td>科普路168号</td>\n",
       "      <td>番禺区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFG1RB78</td>\n",
       "      <td>[]</td>\n",
       "      <td>珍稀濒危植物</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.361881</td>\n",
       "      <td>113.361881</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>188</th>\n",
       "      <td>113.520411,22.290238</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFF2CMPZ</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-树状作物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.520411</td>\n",
       "      <td>113.520411</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>189</th>\n",
       "      <td>113.621186,22.629145</td>\n",
       "      <td>万顷沙镇新垦15涌半百万葵园内</td>\n",
       "      <td>南沙区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFF6B90</td>\n",
       "      <td>[]</td>\n",
       "      <td>百万葵园-薰衣草伊甸园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.621186</td>\n",
       "      <td>113.621186</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>190</th>\n",
       "      <td>113.521023,22.292135</td>\n",
       "      <td>旅游路2428号农科奇观内</td>\n",
       "      <td>香洲区</td>\n",
       "      <td>珠海市</td>\n",
       "      <td>B0FFF2WB6C</td>\n",
       "      <td>[]</td>\n",
       "      <td>农科奇观-沙漠植物园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.521023</td>\n",
       "      <td>113.521023</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>191</th>\n",
       "      <td>113.295619,23.094005</td>\n",
       "      <td>新港西路135号中山大学南校区</td>\n",
       "      <td>海珠区</td>\n",
       "      <td>广州市</td>\n",
       "      <td>B0FFFDBSP6</td>\n",
       "      <td>[]</td>\n",
       "      <td>中山大学广州南校区竹种标本园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>113.295619</td>\n",
       "      <td>113.295619</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>192</th>\n",
       "      <td>111.777369,22.743343</td>\n",
       "      <td>324国道南50米</td>\n",
       "      <td>罗定市</td>\n",
       "      <td>云浮市</td>\n",
       "      <td>B0FFGAHVMI</td>\n",
       "      <td>[]</td>\n",
       "      <td>罗定市海惠生态农业观光示范园</td>\n",
       "      <td>广东省</td>\n",
       "      <td>[]</td>\n",
       "      <td>风景名胜;公园广场;植物园</td>\n",
       "      <td>110103</td>\n",
       "      <td>111.777369</td>\n",
       "      <td>111.777369</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>193 rows × 13 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "                 location                          address adname cityname  \\\n",
       "0    113.367196,23.181797                         天源路1190号    天河区      广州市   \n",
       "1    114.174956,22.578596                          仙湖路160号    罗湖区      深圳市   \n",
       "2      113.52128,22.29402                          健民路328号    香洲区      珠海市   \n",
       "3    110.275886,21.168908                     湖秀新村1号(近湖光岩)    麻章区      湛江市   \n",
       "4    113.620092,22.628194                             新港大道    南沙区      广州市   \n",
       "5    113.900516,22.500264                         月亮湾青青路1号    南山区      深圳市   \n",
       "6    113.770048,22.726385                          和二一路32号    宝安区      深圳市   \n",
       "7    116.756359,23.502012                        广益街道官湖开发区    澄海区      汕头市   \n",
       "8    110.389479,21.251218                         体育南路近体育馆    赤坎区      湛江市   \n",
       "9    110.409452,21.243933                            海湾大桥旁    赤坎区      湛江市   \n",
       "10   113.583777,23.623854                           城郊街西和村    从化区      广州市   \n",
       "11   113.199458,22.654432                     古镇海洲东岸北路396号    中山市      中山市   \n",
       "12   110.906533,21.455614                           325国道旁    电白区      茂名市   \n",
       "13   114.147043,22.563770                             东湖公园    罗湖区      深圳市   \n",
       "14   113.480887,22.539581                        逸仙路君华新城附近    中山市      中山市   \n",
       "15   110.140605,20.382517                        G15沈海高速出口    徐闻县      湛江市   \n",
       "16   113.819593,24.960177                          323国道附近    仁化县      韶关市   \n",
       "17    113.26085,23.464305                           花山镇铁山村    花都区      广州市   \n",
       "18   113.036400,22.549087                         新会劳动大学附近    新会区      江门市   \n",
       "19   113.256478,23.267326                          马岗岭街67号    白云区      广州市   \n",
       "20   110.273411,21.567004                            287省道    廉江市      湛江市   \n",
       "21   113.747687,22.967355                           绿色路99号    东莞市      东莞市   \n",
       "22   114.007608,22.962757                         翠珠路东200米    东莞市      东莞市   \n",
       "23   112.877754,23.188254                 南湖路与森林大道交叉口北100米    三水区      佛山市   \n",
       "24   114.150001,22.565604                          东湖二路21号    罗湖区      深圳市   \n",
       "25   114.147004,22.557208                      沿河北路布心路出口附近    罗湖区      深圳市   \n",
       "26   114.148105,22.563978                          东湖二路12号    罗湖区      深圳市   \n",
       "27   114.150001,22.565105                           东湖二路附近    罗湖区      深圳市   \n",
       "28     113.369492,22.4894                      南环路与永安一路交汇处    中山市      中山市   \n",
       "29   113.672178,24.805628                           新韶镇东山村    浈江区      韶关市   \n",
       "..                    ...                              ...    ...      ...   \n",
       "163  111.881159,21.635098                        麻礼沙村山海经花海    江城区      阳江市   \n",
       "164  113.489325,22.960797                 东环路与长江路交叉口东南100米    番禺区      广州市   \n",
       "165  114.008157,22.540220        侨城东路深南大道8002号深圳国际园林花卉博览园内    福田区      深圳市   \n",
       "166  115.345690,22.864822                        242省道西50米     城区      汕尾市   \n",
       "167  113.299970,23.134819                       环市东路465号西座    越秀区      广州市   \n",
       "168  113.521401,22.291602                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "169  114.227049,22.635539                       横岗安良安兴路64号    龙岗区      深圳市   \n",
       "170  113.359600,23.037920                      小谷围街道广东科学中心    番禺区      广州市   \n",
       "171  113.385399,22.929552                          东兴路306号    番禺区      广州市   \n",
       "172  113.406543,23.035617                      大学城中八路西200米    番禺区      广州市   \n",
       "173  113.264053,23.260056                               []    白云区      广州市   \n",
       "174  114.028122,24.047526                      S347(瑜家农庄旁)    新丰县      韶关市   \n",
       "175  113.592358,23.627597                         城郊街西和村1队    从化区      广州市   \n",
       "176  113.191648,23.386573                中华大街与金华路交叉口东南150米    花都区      广州市   \n",
       "177  114.078000,22.562707                        北环大道1001号    福田区      深圳市   \n",
       "178  113.363991,23.181380  天源路1190号华南植物园世界植物景观温室群景区热带雨林植物室    天河区      广州市   \n",
       "179  111.026469,21.463283                         下里南路东50米    电白区      茂名市   \n",
       "180  110.851024,21.432936                         广湛公路南50米    吴川市      湛江市   \n",
       "181  116.410734,23.348306                           谷饶镇华里乡    潮阳区      汕头市   \n",
       "182  113.484751,22.904370                        清流村十七队观龙岛    番禺区      广州市   \n",
       "183  114.279906,22.638547                            东部华侨城    盐田区      深圳市   \n",
       "184  114.146000,22.563602                              爱国路    罗湖区      深圳市   \n",
       "185  113.366521,23.187930                   天源路1190号华南植物园内    天河区      广州市   \n",
       "186  114.001425,23.803479                               []    从化区      广州市   \n",
       "187  113.361881,23.037000                          科普路168号    番禺区      广州市   \n",
       "188  113.520411,22.290238                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "189  113.621186,22.629145                  万顷沙镇新垦15涌半百万葵园内    南沙区      广州市   \n",
       "190  113.521023,22.292135                    旅游路2428号农科奇观内    香洲区      珠海市   \n",
       "191  113.295619,23.094005                  新港西路135号中山大学南校区    海珠区      广州市   \n",
       "192  111.777369,22.743343                        324国道南50米    罗定市      云浮市   \n",
       "\n",
       "             id importance             name pname  \\\n",
       "0    B00140UEO5         []            华南植物园   广东省   \n",
       "1    B02F37T4NJ         []          深圳仙湖植物园   广东省   \n",
       "2    B02F4000E1         []             农科奇观   广东省   \n",
       "3    B02F701056         []          南亚热带植物园   广东省   \n",
       "4    B00140UFWZ         []             百万葵园   广东省   \n",
       "5    B02F30242B         []       月亮湾公园-青青世界   广东省   \n",
       "6    B02F37VJA4         []       海上田园-趣味植物园   广东省   \n",
       "7    B02F2008RH         []            科隆千树园   广东省   \n",
       "8    B02F70NY85         []           南国热带花园   广东省   \n",
       "9    B02F701S9V         []           中澳友谊花园   广东省   \n",
       "10   B00141ICC6         []           宝趣玫瑰世界   广东省   \n",
       "11   B02F80OWVE         []            南方绿博园   广东省   \n",
       "12   B029C026TX         []         茂名市珍稀植物园   广东省   \n",
       "13   B02F38I7NS         []         东湖公园-杜鹃园   广东省   \n",
       "14   B02F80OXEE         []            华佗山公园   广东省   \n",
       "15   B02F701R7Y         []       中国科学院华南植物园   广东省   \n",
       "16   B02EF0IAI5         []       丹霞山灵溪河森林公园   广东省   \n",
       "17   B00141K7U7         []             香草世界   广东省   \n",
       "18   B02EE01Q23         []   圭峰山风景名胜区-圭峰植物园   广东省   \n",
       "19   B00141JAZ8         []           石马桃花公园   广东省   \n",
       "20   B02F7026HL         []            廉江植物园   广东省   \n",
       "21   B0FFFBDUBN         []            东莞植物园   广东省   \n",
       "22   B0FFHHHXX6         []          常平农业科普园   广东省   \n",
       "23   B02F503M7E         []       三水森林公园-孔圣园   广东省   \n",
       "24   B02F38OY0F         []       东湖公园-观赏花木园   广东省   \n",
       "25   B02F38OY09         []         东湖公园-棕榈园   广东省   \n",
       "26   B02F38OY04         []         东湖公园-树木园   广东省   \n",
       "27   B02F38OXXP         []         东湖公园-古树区   广东省   \n",
       "28   B02F80P8XC         []           中山市树木园   广东省   \n",
       "29   B0FFF00PVD         []           韶关樱花公园   广东省   \n",
       "..          ...        ...              ...   ...   \n",
       "163  B0FFGH195I         []         山海经农业大观园   广东省   \n",
       "164  B0FFHRW1CG         []          萌萌多肉植物园   广东省   \n",
       "165  B02F38SQZQ         []  深圳国际园林花卉博览园-滙芳园   广东省   \n",
       "166  B0FFG7SL6H         []               鸿园   广东省   \n",
       "167  B0FFGSJ62C         []          啊咪要出去玩了   广东省   \n",
       "168  B0FFG2CYJP         []      农科奇观-蝴蝶兰生产区   广东省   \n",
       "169  B0FFGJMI4P         []         慕兰萃植物养肤馆   广东省   \n",
       "170  B0FFH0CZHP         []     广东科学中心-岭南佳果园   广东省   \n",
       "171  B0FFHC9SZN         []         肉嘟嘟多肉植物园   广东省   \n",
       "172  B0FFG0FIGG         []       岭南印象园-乡居田园   广东省   \n",
       "173  B0FFIJYK5I         []          石马桃花种植场   广东省   \n",
       "174  B0FFH5L8K9         []      潘家寨原生态农业观光园   广东省   \n",
       "175  B00141OTQ3         []          天适樱花悠乐园   广东省   \n",
       "176  B00141IBJF         []              资政园   广东省   \n",
       "177  B02F38OY0O         []      笔架山公园-白千层树林   广东省   \n",
       "178  B0FFFXETSP         []      华南植物园-河谷雨林区   广东省   \n",
       "179  B0FFH3Z593         []          九珠教学示范园   广东省   \n",
       "180  B02F700SW3         []            华南农科园   广东省   \n",
       "181  B0FFFABVSG         []            雅香植物园   广东省   \n",
       "182  B0FFHDKCF6         []          胧月多肉植物园   广东省   \n",
       "183  B0FFFDOJ09         []       东部华侨城-三洲茶园   广东省   \n",
       "184  B02F38OY0G         []          东湖公园-花圃   广东省   \n",
       "185  B00141U8UM         []      华南植物园-孑遗植物区   广东省   \n",
       "186  B0FFI7869U         []          桂峰石斛博览园   广东省   \n",
       "187  B0FFG1RB78         []           珍稀濒危植物   广东省   \n",
       "188  B0FFF2CMPZ         []       农科奇观-树状作物园   广东省   \n",
       "189  B0FFFF6B90         []      百万葵园-薰衣草伊甸园   广东省   \n",
       "190  B0FFF2WB6C         []       农科奇观-沙漠植物园   广东省   \n",
       "191  B0FFFDBSP6         []   中山大学广州南校区竹种标本园   广东省   \n",
       "192  B0FFGAHVMI         []   罗定市海惠生态农业观光示范园   广东省   \n",
       "\n",
       "                                           tel              type typecode  \\\n",
       "0                    020-85231993;020-85232037     风景名胜;公园广场;植物园   110103   \n",
       "1                  0755-25738430;0755-25722184     风景名胜;公园广场;植物园   110103   \n",
       "2                    0756-8535999;0756-8535888   风景名胜;风景名胜;国家级景点   110202   \n",
       "3                           0759-2859145;12301     风景名胜;公园广场;植物园   110103   \n",
       "4       020-84956360;020-83309917;020-84956863      风景名胜;公园广场;公园   110101   \n",
       "5    0755-26403988;0755-26646988;0755-26737330    风景名胜;风景名胜;风景名胜   110200   \n",
       "6                                           []    风景名胜;风景名胜;风景名胜   110200   \n",
       "7                  0754-85858327;0754-86985976     风景名胜;公园广场;植物园   110103   \n",
       "8                                 0759-3480019      风景名胜;公园广场;公园   110101   \n",
       "9                                           []      风景名胜;公园广场;公园   110101   \n",
       "10                                020-87907777    风景名胜;风景名胜;省级景点   110203   \n",
       "11                                          []    风景名胜;风景名胜;风景名胜   110200   \n",
       "12                                0668-2699020     风景名胜;公园广场;植物园   110103   \n",
       "13                                          []      风景名胜;公园广场;公园   110101   \n",
       "14                                          []      风景名胜;公园广场;公园   110101   \n",
       "15                                          []     风景名胜;公园广场;植物园   110103   \n",
       "16                   0751-6977261;0751-6291683    风景名胜;风景名胜;风景名胜   110200   \n",
       "17                   020-66609112;020-66609118  风景名胜;风景名胜相关;旅游景点   110000   \n",
       "18                                          []     风景名胜;公园广场;植物园   110103   \n",
       "19                                          []     风景名胜;公园广场;植物园   110103   \n",
       "20                                          []     风景名胜;公园广场;植物园   110103   \n",
       "21                 0769-22985736;0769-27380708     风景名胜;公园广场;植物园   110103   \n",
       "22                                          []      风景名胜;公园广场;公园   110101   \n",
       "23                 0757-87821060;0757-87820806    风景名胜;风景名胜;风景名胜   110200   \n",
       "24                                          []     风景名胜;公园广场;植物园   110103   \n",
       "25                                          []     风景名胜;公园广场;植物园   110103   \n",
       "26                                          []     风景名胜;公园广场;植物园   110103   \n",
       "27                                          []     风景名胜;公园广场;植物园   110103   \n",
       "28                               0760-89886985     风景名胜;公园广场;植物园   110103   \n",
       "29                                          []      风景名胜;公园广场;公园   110101   \n",
       "..                                         ...               ...      ...   \n",
       "163                               0662-3855388  风景名胜;风景名胜相关;旅游景点   110000   \n",
       "164                                         []     风景名胜;公园广场;植物园   110103   \n",
       "165                                         []  风景名胜;风景名胜相关;旅游景点   110000   \n",
       "166                                         []     风景名胜;公园广场;植物园   110103   \n",
       "167                                18819456794     风景名胜;公园广场;植物园   110103   \n",
       "168                                         []     风景名胜;公园广场;植物园   110103   \n",
       "169                                         []     风景名胜;公园广场;植物园   110103   \n",
       "170                                         []     风景名胜;公园广场;植物园   110103   \n",
       "171                                15820272570     风景名胜;公园广场;植物园   110103   \n",
       "172                                         []    风景名胜;风景名胜;风景名胜   110200   \n",
       "173                                         []     风景名胜;公园广场;植物园   110103   \n",
       "174                                         []     风景名胜;公园广场;植物园   110103   \n",
       "175                               020-37941188    风景名胜;风景名胜;风景名胜   110200   \n",
       "176                                         []     风景名胜;公园广场;植物园   110103   \n",
       "177                                         []     风景名胜;公园广场;植物园   110103   \n",
       "178                                         []     风景名胜;公园广场;植物园   110103   \n",
       "179                                         []     风景名胜;公园广场;植物园   110103   \n",
       "180                                         []     风景名胜;公园广场;植物园   110103   \n",
       "181                                         []     风景名胜;公园广场;植物园   110103   \n",
       "182                                         []     风景名胜;公园广场;植物园   110103   \n",
       "183                                         []    风景名胜;风景名胜;风景名胜   110200   \n",
       "184                                         []     风景名胜;公园广场;植物园   110103   \n",
       "185                                         []    风景名胜;风景名胜;风景名胜   110200   \n",
       "186                                         []     风景名胜;公园广场;植物园   110103   \n",
       "187                                         []     风景名胜;公园广场;植物园   110103   \n",
       "188                                         []     风景名胜;公园广场;植物园   110103   \n",
       "189                                         []     风景名胜;公园广场;植物园   110103   \n",
       "190                                         []     风景名胜;公园广场;植物园   110103   \n",
       "191                                         []     风景名胜;公园广场;植物园   110103   \n",
       "192                                         []     风景名胜;公园广场;植物园   110103   \n",
       "\n",
       "              经           纬  \n",
       "0    113.367196  113.367196  \n",
       "1    114.174956  114.174956  \n",
       "2     113.52128   113.52128  \n",
       "3    110.275886  110.275886  \n",
       "4    113.620092  113.620092  \n",
       "5    113.900516  113.900516  \n",
       "6    113.770048  113.770048  \n",
       "7    116.756359  116.756359  \n",
       "8    110.389479  110.389479  \n",
       "9    110.409452  110.409452  \n",
       "10   113.583777  113.583777  \n",
       "11   113.199458  113.199458  \n",
       "12   110.906533  110.906533  \n",
       "13   114.147043  114.147043  \n",
       "14   113.480887  113.480887  \n",
       "15   110.140605  110.140605  \n",
       "16   113.819593  113.819593  \n",
       "17    113.26085   113.26085  \n",
       "18   113.036400  113.036400  \n",
       "19   113.256478  113.256478  \n",
       "20   110.273411  110.273411  \n",
       "21   113.747687  113.747687  \n",
       "22   114.007608  114.007608  \n",
       "23   112.877754  112.877754  \n",
       "24   114.150001  114.150001  \n",
       "25   114.147004  114.147004  \n",
       "26   114.148105  114.148105  \n",
       "27   114.150001  114.150001  \n",
       "28   113.369492  113.369492  \n",
       "29   113.672178  113.672178  \n",
       "..          ...         ...  \n",
       "163  111.881159  111.881159  \n",
       "164  113.489325  113.489325  \n",
       "165  114.008157  114.008157  \n",
       "166  115.345690  115.345690  \n",
       "167  113.299970  113.299970  \n",
       "168  113.521401  113.521401  \n",
       "169  114.227049  114.227049  \n",
       "170  113.359600  113.359600  \n",
       "171  113.385399  113.385399  \n",
       "172  113.406543  113.406543  \n",
       "173  113.264053  113.264053  \n",
       "174  114.028122  114.028122  \n",
       "175  113.592358  113.592358  \n",
       "176  113.191648  113.191648  \n",
       "177  114.078000  114.078000  \n",
       "178  113.363991  113.363991  \n",
       "179  111.026469  111.026469  \n",
       "180  110.851024  110.851024  \n",
       "181  116.410734  116.410734  \n",
       "182  113.484751  113.484751  \n",
       "183  114.279906  114.279906  \n",
       "184  114.146000  114.146000  \n",
       "185  113.366521  113.366521  \n",
       "186  114.001425  114.001425  \n",
       "187  113.361881  113.361881  \n",
       "188  113.520411  113.520411  \n",
       "189  113.621186  113.621186  \n",
       "190  113.521023  113.521023  \n",
       "191  113.295619  113.295619  \n",
       "192  111.777369  111.777369  \n",
       "\n",
       "[193 rows x 13 columns]"
      ]
     },
     "execution_count": 16,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# 使用 .assign 增加新栏位字段\n",
    "df = df.assign( 经 = [x.split(',')[0] for x in df['location']])\n",
    "df = df.assign( 纬 = [x.split(',')[1] for x in df['location']])\n",
    "# 旧写法\n",
    "# df[\"经\"] = [x.split(',')[0] for x in df['location']]\n",
    "# df[\"纬\"] = [x.split(',')[1] for x in df['location']]\n",
    "df"
   ]
  },
  {
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "### pandas 輸出\n",
    "- [pandas.DataFrame.to_csv](http://pandas.pydata.org/pandas-docs/stable/generated/pandas.DataFrame.to_csv.html)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "metadata": {},
   "outputs": [],
   "source": [
    "df.to_csv(\"amap_data_for_visualization.tsv\", encoding=\"utf8\", sep='\\t') "
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
